Home » SQL & PL/SQL » SQL & PL/SQL » How to check whether the value is there in the database or not (windows)
How to check whether the value is there in the database or not [message #351767] Thu, 02 October 2008 23:15 Go to next message
kishoredevagupthapu
Messages: 1
Registered: October 2008
Junior Member
Hi all


Hope all are doing well

my question is

I want to check whether the particular value is in the database or not
Can i get it using a simple sql query??
Re: How to check whether the value is there in the database or not [message #351770 is a reply to message #351767] Fri, 03 October 2008 00:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Can i get it using a simple sql query??

Simple query, not, but a PL/SQL block.
Have a look at T. Kyte find_string function.

Regards
Michel
Re: How to check whether the value is there in the database or not [message #351794 is a reply to message #351767] Fri, 03 October 2008 03:53 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
hi,
if you meean any value exists in table column, then you shall use nvl
if you are specific on some values on particular table column
you shall use decode
yours
dr.s.raghunathan

Re: How to check whether the value is there in the database or not [message #351813 is a reply to message #351794] Fri, 03 October 2008 05:38 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I'm curious - why would you need to use NVL to check whether a given value exists in a column of a table?
Re: How to check whether the value is there in the database or not [message #351817 is a reply to message #351813] Fri, 03 October 2008 05:53 Go to previous message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
my mind creeped with is null and is not null and i just want to hint. nvl flowed out.. sorry
yours
dr.s.raghunathan
Previous Topic: SYSDATE Performance
Next Topic: Wrap command
Goto Forum:
  


Current Time: Sun Dec 11 04:19:05 CST 2016

Total time taken to generate the page: 0.08920 seconds