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 joins in sql?

693

---

what are the advantages and disadvantages of cascading style sheets? : Sql dba

803

---

Is merge a dml statement?

731

---

What is pragma in sql?

819

---

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1279

---

---

How do you go back in sql?

701

---

What is orm in sql?

723

---

How much does sqlite cost?

725

---

how to include numeric values in sql statements? : Sql dba

770

---

What is foreign key sql?

748

---

What is tuple in sql?

733

---

What is right join in sql?

744

---

How bulk collect improves performance?

742

---

How does postgresql compare to mysql?

761

---

What is the difference between instead of trigger and after trigger?

697

---