Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Select a column name with an embedded space

PSULionRPJun 24 2009 — edited Jun 24 2009
I have created an In-Line View or Derived Table and my column alias is "ER Number". How can I then SELECT this column??? In SQL Server, all you need to do is put [] around it....i.e. [ER Number]

Thanks for your review and reply.

PSULionRP
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 22 2009
Added on Jun 24 2009
2 comments
4,449 views