Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Does Null value refer to empty value in SQL?

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 07-01-2011
Member
 
Join Date: Dec 2010
Posts: 48
Does Null value refer to empty value in SQL?
  

I am a student of IT student , I want to be a Data base administrator in future or you can say a DBA , yes I know that it is a very difficult task if all your database concepts, SQL or Oracle Concepts are not clear , so I want to do this subject thorough and clear each and every doubt, so after taking my friends advice I am posting my question in this forum, I wanted to ask that are the null value concept equal to an empty value.

Reply With Quote
  #2  
Old 07-01-2011
Member
 
Join Date: May 2009
Posts: 620
Re: Does Null value refer to empty value in SQL?

Yes indeed you will have to clear all those questions very clear , infact these all are very small and base concepts, apart from that I will recommend you to appear the exam for Oracle and you will get the certificate once you clear the exams , if you ask me about the null concept according to me it refers to any missing value. I will not say that it is equivalent to empty value.
Reply With Quote
  #3  
Old 07-01-2011
Member
 
Join Date: May 2009
Posts: 533
Re: Does Null value refer to empty value in SQL?

I also used to get very confused in my college days about this null value concept, if you ask me about null value concept , I have a very good example for about this concept of null value , suppose a student has an exam and one day he does not appear it due to bad health, then there if you are making a database entry you will put there a NUll value.
Reply With Quote
  #4  
Old 07-01-2011
Member
 
Join Date: May 2009
Posts: 525
Re: Does Null value refer to empty value in SQL?

The Null value concept is the most arguable concept in the SQL, some said that it is a zero value and some says that there is an empty value , but there is neither a zero nor an empty value, the Null value in an relational database refers to a value where there is a value applicable but it is actually unknown , you can refer to the above example, you will understand it easily.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Does Null value refer to empty value in SQL?"
Thread Thread Starter Forum Replies Last Post
Best Javascript Book to refer? BSOD.K Software Development 4 12-04-2012 06:29 PM
What does memory.dmp file refer to cupid! Windows XP Support 3 23-03-2012 10:52 AM
Want to learn ActionScript.....What to Refer? Andrzej Software Development 3 14-11-2009 12:12 PM
SQL need to check null or empty string B_Hodge Software Development 3 18-06-2009 11:44 AM
How do I refer to a Jasper Report nanakofiboafo Software Development 2 04-05-2009 07:09 PM


All times are GMT +5.5. The time now is 11:07 PM.