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 -> Re: Two plsql noob questions - Thank you!

Re: Two plsql noob questions - Thank you!

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 07 Feb 2007 12:53:27 -0800
Message-ID: <1170881605.822241@bubbleator.drizzle.com>


jobs wrote:
> 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.

Nothing you posted says "missing key word." Repost with your version and copy from your screen so we can see what is actually happening.

There is no such thing as the "top row." What is it you are trying to do?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Feb 07 2007 - 14:53:27 CST

Original text of this message

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