What is the difference between an "empty" value and a "null" value?

Options
- They both are the same.
- A null value is treated as a empty string in Oracle
- You cannot query a null value
- An empty string is treated as a null value in Oracle


CORRECT ANSWER : An empty string is treated as a null value in Oracle

Discussion Board
Empty Value and Null Value

An empty string is treated as a null value in Oracle. A NULL value represents the absence of a value for a record in a field (other software calls it a missing value). An empty value is a "field-formatted" value with no significant data in it. Null has no bounds, it can be used for string, integer, date, etc. fields in a database. Empty string is just regarding a string. If you have no value for a field, use null, not an empty string.

Prajakta Pandit 02-15-2017 04:00 AM

plsql

null waits for a values while blank not

Anil 08-28-2014 01:43 PM

Write your comments

 
   
 
 

Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement