Home » SQL & PL/SQL » SQL & PL/SQL » Please kindly help me in this UPDATE command
Please kindly help me in this UPDATE command [message #187841] Tue, 15 August 2006 23:50 Go to next message
kumarvk
Messages: 211
Registered: July 2004
Senior Member
Dear Experts,

I have a update statement like this

update sscd a set a.amt=(select b.YN*0.013652 from ssch b
WHERE A.CNO=b.CNO AND a.description='BOF' AND
A.CNO=(SELECT C.CNO FROM CCR C WHERE A.CNO=C.CNO
AND C.REF_NO=1725))

when I run this it says

ORA-01407: cannot update ("CSS"."SSCD"."AMT") to NULL


Can any expert help me in this regard.

Re: Please kindly help me in this UPDATE command [message #187846 is a reply to message #187841] Wed, 16 August 2006 00:21 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Would something like this help?
update sscd a set
  a.amt = (select b.yn * 0.013652
           from ssch b
           where b.cno = a.cno
          )
where a.description = 'BOF' 
  and a.cno = (select c.cno
               from ccr c
               where c.cno = a.cno
                 and c.ref_no = 1725
              )
  and exists (select null from ssch b
              where b.cno = a.cno
             );
Previous Topic: Tables with datatype 'LONG'
Next Topic: Declare private attribute of Object type
Goto Forum:
  


Current Time: Sun Dec 04 17:06:30 CST 2016

Total time taken to generate the page: 0.06993 seconds