Answer / Jagdeesh Chandra Kesharwani

PL/SQL INTEGER is a data type used to represent whole numbers without decimal points. It can store values ranging from -2147483648 to 2147483647.

what is the different between now() and current_date()? : Sql dba

1 Answers  

---

how to create a database in oracle?please gve anser with example

1 Answers  

---

What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

2 Answers   JDA,

---

What are sql functions? Describe in brief different types of sql functions?

1 Answers  

---

What is the difference between join and natural join?

1 Answers  

---

overloading of stored procedure is possible in oracle?

3 Answers   Nelco,

---

What is the order of sql select?

1 Answers  

---

How are sql commands classified?

1 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,

---

What does subquery mean in sql?

1 Answers  

---

If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 Answers  

---

Are left and right joins the same?

1 Answers  

---