Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Two plsql noob questions - Thank you!
How do I select into multiple variables? this is saying missing key
word.
select LOGTYPE, ERROR, ERRORMSG into status, CPMERROR, CPMERRMSG from cpm_errorlog;
How do I select the top row?
select LOGTYPE, ERROR, ERRORMSG into status, CPMERROR, CPMERRMSG from cpm_errorlog where cpmjobno=CPMJOBNO and rownum = 1 order by logdate desc;
Thanks in advance for any help or information. Received on Wed Feb 07 2007 - 12:01:45 CST