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

What is bulk collect in pl sql?

543

---

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com

2078

---

Do prepared statements prevent sql injection?

538

---

what are the drivers in mysql? : Sql dba

572

---

Is join and inner join the same?

553

---

---

how can we optimize or increase the speed of a mysql select query? : Sql dba

517

---

What is substitution variable in pl sql?

517

---

Is primary key is clustered index?

535

---

How do you change a value in sql?

564

---

What is the difference between cross join and natural join?

578

---

Is sql better than excel?

525

---

What is substitution variable?

591

---

What is the maximum number of rows in sql table?

555

---

what is schema? : Sql dba

572

---

What are stored procedures in mysql?

576

---