![pl sql developer explain plan pl sql developer explain plan](https://www.red-gate.com/simple-talk/wp-content/uploads/2020/11/word-image-31.png)
In SQL null value is not equal to itself.So null=null is false and the output of above query is ‘Ayan’. Select case when null=null then ‘Rohit’ Else ‘Ayan’ from dual
#PL SQL DEVELOPER EXPLAIN PLAN UPDATE#
This means that you cannot insert a new record, or update a record without adding a value to this field.Ħ.What is the output of following Query? The NOT NULL constraint enforces a field to always contain a value. The NOT NULL constraint enforces a column to NOT accept NULL values. A field with a NULL value is one that has been left blank during record creation.īy default, a table column can hold NULL values. It is very important to understand that a NULL value is different than a zero value or a field that contains spaces.
#PL SQL DEVELOPER EXPLAIN PLAN FOR FREE#
SQL Developer Interview Questions : SQL Interview Book DOWNLOAD FOR FREE