Home » SQL & PL/SQL » SQL & PL/SQL » Query (merged 3)
Query (merged 3) [message #402470] Mon, 11 May 2009 00:21 Go to next message
sayhdnas
Messages: 3
Registered: May 2009
Junior Member
Hi

i have two tables Table A and Table B. Table A has a two columns Doc_id and File_id. foe each doc_id there can be n number of File_id.now even if one file_id exists for doc_id i wish to update a column flag in Table B. how do i do it?
Re: query [message #402471 is a reply to message #402470] Mon, 11 May 2009 00:23 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

Post DDL for tables.
Post DML for test data.

Post expected/desired results.
Oracle 9i - query [message #402473 is a reply to message #402470] Mon, 11 May 2009 00:26 Go to previous messageGo to next message
sayhdnas
Messages: 3
Registered: May 2009
Junior Member
Hi

I am learning now. i have two tables A nd B. Table A has 2 columns Doc_id and file_id. A documenty id can have many file_id's. i now want to update a Flag in Table B when even one file _id exists for doc_id. what is the query...how do i do? Please help
Re: Oracle 9i - query [message #402474 is a reply to message #402473] Mon, 11 May 2009 00:28 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/m/402471/136107/#msg_402471

Do not cross/multi-post!
Oracle 9i - query [message #402475 is a reply to message #402470] Mon, 11 May 2009 00:30 Go to previous messageGo to next message
sayhdnas
Messages: 3
Registered: May 2009
Junior Member
Hi

I am learning now. i have two tables A nd B. Table A has 2 columns Doc_id and file_id. A documenty id can have many file_id's. i now want to update a Flag in Table B when even one file _id exists for doc_id. what is the query...how do i do? Please help
Re: Oracle 9i - query [message #402477 is a reply to message #402475] Mon, 11 May 2009 00:31 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Stop spamming this forum!
Re: Query (merged 3) [message #402478 is a reply to message #402470] Mon, 11 May 2009 00:40 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Stop repeating the same question and post what BlackSwan asked you.
In other words post a working Test case: create table and insert statements along with the result you want with these data.

Also choose a meaningful title, do you know how many topics are named "query"? How do you find your own?

Regards
Michel
Previous Topic: concert number to string like (1,one)
Next Topic: ORA-14074: partition bound must collate higher than that of the last partition
Goto Forum:
  


Current Time: Fri Dec 09 17:28:56 CST 2016

Total time taken to generate the page: 0.28976 seconds