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
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
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.


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: 65085
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.

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

Current Time: Mon Jul 24 20:12:28 CDT 2017

Total time taken to generate the page: 0.10810 seconds