Please use this board to give us your feedback and site related enhancement requests
uday
Printable View
Please use this board to give us your feedback and site related enhancement requests
uday
how can i post the new thread?
Kanika,
You can email me at lcole@internet.com
hi,
I've 2 tables
gmastr with these
army_no varchar2(32) primary key
paosfrel with these
army_no varchar2(2)
my query is
update gmastr set r_code =(select r_code from paosfrel
where gmastr.army_no = paosfrel.army_no)
where gmastr.r_code is not null
where I run this query I get this error:
ORA-01427 - single-row subquery returns more than one row
thanks for the feedback
Hi, My name is Magdalena. I am already a mom of two grown up ladies but so confident to say that I'm still interested in internet searching. One of my fave past times is to participate in forums likewise to share and learn new things like Oracle. I'm thankful to be one of you here. Greetings to everyone and hoping we'll all have a fresh start to this site:)