How to list all indexes in your schema?

0 Answers  

---

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

0 Answers  

---

i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions

4 Answers   CGI,

---

What is a cursor variable?

0 Answers  

---

How to define an anonymous procedure without variables?

0 Answers  

---

if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.

1 Answers   MasterCard,

---

What is autonomous transaction?

6 Answers  

---

What are the attributes that are found in a cursor?

0 Answers  

---

5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.

6 Answers   Wipro,

---

What do you mean by group by clause?

0 Answers  

---

Define 'view' advantage ?

2 Answers   AZTEC, TCS,

---

How to view existing locks on the database?

0 Answers  

---