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

Explain the working of primary key?

1150

---

What is a parameter query?

1141

---

What is varchar used for?

1135

---

Is sql a scripting language?

1082

---

What are the benefits of pl/sql packages?

1155

---

What are the triggers associated with image items?

1086

---

Can a varchar be a primary key?

1045

---

What are the different types of tables in sql?

1062

---

Is a secondary key the same as a foreign key?

1113

---

what are the authentication modes in sql server? : Sql dba

1116

---

What is an index in sql with example?

1018

---

What is sql*loader and what is it used for?

1216

---

What is the difference between delete and truncate statement in sql?

1124

---

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1269

---

Explain the difference in execution of triggers and stored procedures?

1060

---