Re: too many values?

From: Alan Mills <Alan.Mills_at_nospamservices.fujitsu.com>
Date: Wed, 20 Nov 2002 15:37:30 -0000
Message-ID: <arga7r$2e33$1@news.icl.se>

"tony" <meinhfxNOSPAM_at_hotmail.com> wrote in message news:3ddba70f.7392436_at_news.dal.ca...
> Hi. I'd like to do a "select into" in pl/sql but I am getting a too
> many values error. How can I select only the first value that
> satisfies the query?
>

Add WHERE ROWNUM = 1 to the bottom of your query. Received on Wed Nov 20 2002 - 09:37:30 CST

This message: [ Message body ]
Next message: Fred Zimmerman: "Function similar to SQL Server Convert() ???"
Previous message: s Lehaire: "user-schema ??"
In reply to: tony: "too many values?"
Next in thread: Daniel Morgan: "Re: too many values?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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