Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Closed TopicStart new topic
> [URGENT] Help with NULLs & EMPTY values
SidM
post Feb 5 2011, 01:11 PM
Post #1


Newbie
*

Group: Members
Posts: 2
Joined: 5-February 11
Member No.: 44,652



I have table (tbstudent) with 3 fields (stname,stmarks,stroll) , then i have created another table(tbbooks) with 2 fields (stbook,stroll) now what i m doing is that i want the names of just the books from table 2 which have been issued to students with thee names not starting with say 'v' the query that i m running is

SELECT STROLL FROM TBBOOKS WHERE STROLL NOT IN (SELECT STROLL FROM TBSTUDENT WHERE STNAME NOT LIKE 'V%');

the query is running fine if all values are present or even if there a null value passed to the row(s)

but when i insert a row with a empty value present in the table it returns no answer.
Go to the top of the page
 
+Quote Post
SteveC
post Feb 5 2011, 01:33 PM
Post #2


Advanced Member
***

Group: Members
Posts: 2,835
Joined: 11-March 08
Member No.: 18,933



Sorry, homework problems are not urgent.

http://www.dba-oracle.com/sql/t_subquery_not_in_exists.htm
Go to the top of the page
 
+Quote Post
SidM
post Feb 5 2011, 03:13 PM
Post #3


Newbie
*

Group: Members
Posts: 2
Joined: 5-February 11
Member No.: 44,652



thanx bro for the help

actually wrote urgent as i needed it immediately
sorry wont use it again
Go to the top of the page
 
+Quote Post

Closed TopicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 2nd September 2014 - 11:38 AM