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 everything PLUS something as something

koszta5Apr 22 2010 — edited Apr 22 2010
Hi, I am kinda used to Postgre and I wanna do this (I think this example will make it clear):

select *, id_person AS myid FROM people
=> I can do this in Postgre and it just selects everything PLUS a column of id_person renamed to myid
=> I am unable to do this in Oracle, it just gives me "ORA-00923: didnt find FROM where expected" cra*.

Is there any way around this, I know there must be but I just couldnt google it around so I would really appreciate if you helped the noob :)
thanks

Edited by: koszta5 on Apr 22, 2010 9:23 AM
This post has been answered by Boneist on Apr 22 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 20 2010
Added on Apr 22 2010
4 comments
574 views