Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Two plsql noob questions - Thank you!

Two plsql noob questions - Thank you!

From: jobs <jobs_at_webdos.com>
Date: 7 Feb 2007 10:01:45 -0800
Message-ID: <1170871305.181845.219210@k78g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US