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

[Magdalena Mouri]

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