Explain commit, rollback and savepoint.

0 Answers  

---

What are tables and fields in the database?

0 Answers  

---

Can we delete column in sql?

0 Answers  

---

how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used

11 Answers   UST,

---

How do you rename a table in sql?

0 Answers  

---

---

I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body

1 Answers   TCS,

---

We have a CURSOR then we need BULK COLLECT?

1 Answers  

---

What is the main reason behind using an index?

0 Answers  

---

Is it possible to update views?

0 Answers  

---

Show the two pl/sql cursor exceptions.

0 Answers  

---

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,

---

how to select first 5 records from a table? : Sql dba

0 Answers  

---