select everything PLUS something as something
koszta5Apr 22 2010 — edited Apr 22 2010Hi, 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