In both SQL and Oracle, I can do this: "Select *", where * means all the fields in all the tables in the FROM clause. But in SQL, and NOT IN ORACLE, I can also do this: "Select len (p.Last_Name), *", where one field is singled out for special attention, and given the qualifer "P", and * once again means all fields from all tables. Why does this not work in Oracle? It seems that once a field has been qualified, then "*" will not work, and I have to do a.*, b.*, etc for each table in the FROM clause.
-- -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en --- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracle-plsql+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
