in Oracle SQL Developer I am runing :
SELECT 'XYZ' , * FROM ALL_TABLES ;
and get this error:
ORA-00936: missing expression 00936. 00000 - "missing expression" *Cause:
*Action: Error at Line: 14 Column: 14
it runs fine when I run:
SELECT 'XYZ' , * FROM ALL_TABLES ;
Many thanks
If you want to combine * with an additional column in your SELECT clause, you have to use a table alias:
SELECT 'XYZ' , at.* FROM ALL_TABLES at;
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments