Answer Posted / archana

begin
if null is null then
dbms_output.put_line('null');
else
dbms_output.put_line('not null');
end if
end;

now it will return null
it is recommended to use 'is' with null not ' ='

Why do we use partitions in sql?

970

---

What is %type in pl sql?

921

---

explain mysql aggregate functions. : Sql dba

939

---

Is join an inner join?

893

---

What are different clauses used in sql?

1066

---

What is trigger in sql? Explain

938

---

What is the difference between a primary key and a clustered index?

926

---

What are the different types of sql commands?

1055

---

What are the three pl sql block types?

945

---

Does inner join remove duplicates?

884

---

Can there be more than one function with a similar name in a pl/sql block?

921

---

What is data profiling in sql?

1014

---

define sql update statement ? : Sql dba

1048

---

How to use boolean type in select statement?

991

---

What is a constraint?

959

---