Oracle - column aliasing...

bonkey

So I have this query...

SELECT  foo as bar
  FROM  mytable

OK...obviously my query is more complex than that, but its pretty irrelevant to my question

The problem is that I don't want to alias foo to bar. I want to alias foo to 'ba r'. But Oracle doesn't seem to want to let me.

in MSSQL, I could just do :

SELECT  foo as 'ba r'
  FROM  mytable

Will Oracle let me do this at all, or should I do something like :

SELECT  foo as 'ba_r'
  FROM  mytable

and then post-process the recordset in my app, replacing the _ with a space char in each column name after I read them from the recordset definition?

Any thoughts?

jc

bonkey

Duh.

SELECT  foo as "ba r"
  FROM  myTable

TFIF...

jc