Answer / guest

The goal of the optimizer is to choose the most efficient
way to execute a SQL statement.

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

1 Answers   Oracle,

---

I have a table like this Table Name:Products Productid Price 1 10 1 10 2 20 3 30 3 30 But i want to output like this. productid price 2 20. please replay me.

3 Answers   TCS,

---

Which Oracle App Is Most Popular One ?

3 Answers  

---

How to delete all rows a table in oracle?

0 Answers  

---

How to find out what oracle odbc drivers are installed?

0 Answers  

---

How to get a list of all background sessions in the database?

0 Answers  

---

what is the difference between authorization and authentication?

4 Answers   MAHINDRA, PUCIT,

---

Give the various rollback segment states.

0 Answers  

---

Is primary key indexed by default in oracle?

0 Answers  

---

why can't we assign not null constraint as table level constraint

3 Answers   CTS, Wipro,

---

Explain the use of full option in exp command.

0 Answers  

---

i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?

2 Answers   Microsoft,

---