Home » SQL & PL/SQL » SQL & PL/SQL » How to get the value
How to get the value [message #378889] Fri, 02 January 2009 05:02 Go to next message
SUMISHA
Messages: 2
Registered: October 2007
Location: CHENNAI
Junior Member
Hi all,
I need a help to fetch the column.Let me brief out..I have two table with one column link but the values in two columns are different.
table 1:
col 1 :
values = 001

table 2:
col 1 :
values = '001','002','003'

Now i need check that the column value 001 of table 1 is there is cloumn 1 of table 2 ..

I have tried with substr and instr functions but i couldn't..can any one help me..
Re: How to get the value [message #378891 is a reply to message #378889] Fri, 02 January 2009 05:12 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Welcome to the forum.

Why don't you post what you have tried so far and I am sure somebody will help you. In the mean time search for "varying in-list" in this forum and also spend some time reading the forum guidelines.

Regards

Raj
Re: How to get the value [message #378896 is a reply to message #378889] Fri, 02 January 2009 05:57 Go to previous message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at INSTR function.
Also I advice you to read Normalization wiki page.

Regards
Michel
Previous Topic: How to Calculate the size of Database ,function,Procedure,Package etc.
Next Topic: How to use REF OF..
Goto Forum:
  


Current Time: Wed Dec 07 11:03:08 CST 2016

Total time taken to generate the page: 0.09004 seconds