Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Oracle - column aliasing...

  • 07-05-2004 2:19pm
    #1
    bonkey
    Registered Users, Registered Users 2 Posts: 15,443 ✭✭✭✭


    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


Comments

  • #2
    bonkey
    Registered Users, Registered Users 2 Posts: 15,443 ✭✭✭✭bonkey


    Duh.
    SELECT  foo as "ba r"
  FROM  myTable

    TFIF...

    jc


Advertisement