in PL/SQL context this select syntax does not work On 25. 5. 2010 18:56, reach manju wrote:
select...from tab1 where col1=c1.col1 and col2=c1.col2
select...from tab1 *INTO variable* where col1=c1.col1 and col2=c1.col2 you forgot INTO statement which is mandatory! Andrej Hopko -- 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