OraFAQ Forum: SQL & PL/SQL » Query (merged 3)

Home » SQL & PL/SQL » SQL & PL/SQL » Query (merged 3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Query (merged 3) [message #402470]

Mon, 11 May 2009 00:21

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?

Report message to a moderator

Re: query [message #402471 is a reply to message #402470]

Mon, 11 May 2009 00:23

BlackSwan
Messages: 26766
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.

Report message to a moderator

Oracle 9i - query [message #402473 is a reply to message #402470]

Mon, 11 May 2009 00:26

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

Report message to a moderator

Re: Oracle 9i - query [message #402474 is a reply to message #402473]

Mon, 11 May 2009 00:28

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/m/402471/136107/#msg_402471

Do not cross/multi-post!

Report message to a moderator

Oracle 9i - query [message #402475 is a reply to message #402470]

Mon, 11 May 2009 00:30

sayhdnas
Messages: 3
Registered: May 2009

Junior Member

Report message to a moderator

Re: Oracle 9i - query [message #402477 is a reply to message #402475]

Mon, 11 May 2009 00:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Stop spamming this forum!

Report message to a moderator

Re: Query (merged 3) [message #402478 is a reply to message #402470]

Mon, 11 May 2009 00:40

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 18:21:28 CST 2024