Explain what are the advantages of views?

0 Answers  

---

In Exception handling if we are using the when others first then what happens . whether it will show the compiler error

2 Answers   HCL,

---

Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.

2 Answers  

---

What is PL/SQL ?

3 Answers  

---

How to use windows user to connect to the server?

0 Answers  

---

Can select statements be used on views in oracle?

0 Answers  

---

how many types of index?

2 Answers   Cap Gemini, TCS,

---

How to list all indexes in your schema?

0 Answers  

---

how to retrieve 1st and last row of table without using group functions??

6 Answers  

---

3. Display all the client numbers in the ORDER table. Remove duplicates.

1 Answers   Wipro,

---

i have a table with the columns below as Emp_ID Address_ID Address_Line City Country -------- --------- ----------- ------ --------- Q: Display the Emp_ID's those having more than one Address_ID

7 Answers   IBM,

---

What are the Referential actions supported by FOREIGN KEY integrity constraint ?

1 Answers  

---