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 ' ='

How do I remove sql developer from windows 10?

501

---

How does a trigger work?

531

---

How to test for null values?

598

---

What are stored procedures used for?

528

---

what is the command used to fetch first 5 characters of the string? : Sql dba

1128

---

---

What are the possible values for the boolean data field?

511

---

What are the 3 types of behavioral triggers?

653

---

How can you view the errors encountered in a trigger?

539

---

can a stored procedure call itself or recursive stored procedure? : Sql dba

570

---

What is scalar and vector?

521

---

How is a process of pl/sql compiled?

594

---

Can a varchar be a primary key?

532

---

Is a foreign key always unique?

524

---

Do stored procedures prevent sql injection?

539

---

Is sql considered coding?

563

---