Answer / Pankaj Kumar Pandey

An explicit cursor is used in PL/SQL when you want to execute a SELECT statement repeatedly and process the rows one by one, as opposed to an implicit cursor, which is automatically created by the database.

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,

---

how can create data base link for tow servers (scott schema) give examples plz

2 Answers  

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

1 Answers  

---

How will we see framework of a table?

2 Answers   Accenture,

---

What type of database is cloud sql?

1 Answers  

---

how to escape special characters in sql statements? : Sql dba

0 Answers  

---

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

1 Answers  

---

What is string data type in sql?

1 Answers  

---

What is the limitation on the block size of pl/sql?

1 Answers  

---

Does group by remove duplicates?

0 Answers  

---

What is the use of pl/sql table?

1 Answers  

---

How do you update a value in sql?

1 Answers  

---