RE: SQL dummy

From: Robertson Lee - lerobe <Lee.Robertson_at_acxiom.com>
Date: Fri, 6 Mar 2009 17:41:42 -0000
Message-ID: <F1A191B056E5E04EA2134D842F9396F8152170A6_at_sunmsx01.Corp.Acxiom.net>

Thanks Niall, I did try that honestly but I just isn't working. This should be so EASY !!!!!!!!!

-----Original Message-----
From: Niall Litchfield [mailto:niall.litchfield_at_gmail.com] Sent: 06 March 2009 17:34
To: Robertson Lee - lerobe; oracle-l
Subject: Re: SQL dummy

Lee. You just want to include the literal in the initial select. That is select col1, col2,col3,'literal' from ...

On 3/6/09, Robertson Lee - lerobe <Lee.Robertson_at_acxiom.com> wrote:
> OK,
>
> I am the first one to admit I very rarely am called upon to write SQL,
> so when some does come along I have to struggle.
>
> What I need to do is insert some information into a table and include
a
> literal
>
> This is what I have been trying but I just cannot get it to work. If I
> take the task_status bit out (the value I am trying to insert into
that
> column is at the very bottom of the statement) then the whole thing
> works like a charm
>
> Please help, my brain is farting merrily on a Friday afternoon :-)
>
> The error I get is ORA-00913: too many values. I realise this is
because
> I am trying to push too many values from my original select. I have
> redone this lots of ways but still to no avail.
>
> I realise I have to somehow pull the table values from the tables and
> the literal from dual but I cannot figure out how.
>
> INSERT INTO lr_build
> (
> num_build,
> task_type,
> task_name,
> task_status
> )
> SELECT
> (SELECT v.num_build num_build,
> v.task_type task_type,
> v.task_name task_name
> FROM lr_task_stat v, leecvl c
> WHERE c.VARIABLE_VALUE = 'P'
> AND c.NUM_BUILD = v.num_build
> AND c.TASK_TYPE = v.TASK_TYPE
> AND c.TASK_NAME = v.TASK_NAME
> AND NOT EXISTS
> (SELECT 1 from lr_build b
> WHERE b.NUM_BUILD = c.NUM_BUILD
> AND b.TASK_TYPE = c.TASK_TYPE
> AND b.TASK_NAME = c.TASK_NAME)),
> 'N Started' task_status
> from dual
> ;
>
>

---

***
> The information contained in this communication is confidential, is
> intended only for the use of the recipient named above, and may be
legally
> privileged.
>
> If the reader of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution or copying of
this
> communication is strictly prohibited.
>
> If you have received this communication in error, please resend this
> communication to the sender and delete the original message or any
copy
> of it from your computer system.
>
> Thank You.
>

---

---

>

-- 
Sent from Google Mail for mobile | mobile.google.com

Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Mar 06 2009 - 11:41:42 CST