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 to set up sql*plus output format in oracle?

1040

---

What is trigger in sql? Explain

999

---

What is posting?

1041

---

What are the types of sql commands?

1104

---

What is count * in sql?

1001

---

what is a trigger? : Sql dba

1033

---

what is data manipulation language? : Sql dba

1022

---

How do you identify a primary key?

1066

---

List and explain the different types of join clauses supported in ansi-standard sql?

1357

---

How much does sqlite cost?

1045

---

Does group by remove duplicates?

1046

---

what is a tablespace? : Sql dba

1057

---

What plvcmt and plvrb does in pl/sql?

1324

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

4025

---

What is record in pl sql?

1087

---