What is the function that is used to transfer a pl/sql table log to a database table?

0 Answers  

---

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

0 Answers   IBM,

---

How delete all records from table in sql?

0 Answers  

---

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

---

The select into statement is most often used to create backup copies of tables or for archiving records?

0 Answers  

---

What is execute immediate?

0 Answers  

---

Can we commit inside a trigger?

0 Answers  

---

what is the difference between trigger and storedprocedures

16 Answers   Tech Mahindra,

---

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

7 Answers   Oracle,

---

How do you use join?

0 Answers  

---

Why cross join is used?

0 Answers  

---

there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?

12 Answers   Oracle,

---