Post your Feedback and Site related questions here

[uday]

Please use this board to give us your feedback and site related enhancement requests

uday

[dbasureshkumar]

how can i post the new thread?

[kanika]

Please use this board to give us your feedback and site related enhancement requests

uday

i need to send him/her a private email but dont know the address or username...tried searching the forum but cud not find...plz let me know ASAP!!!

Thanks

[lcole]

Kanika,

You can email me at lcole@internet.com

[urbhatti77]

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

[davey23uk]

thanks for the feedback