what is the difference between cluster and non cluster index? : Sql dba

0 Answers  

---

What are triggers in sql?

0 Answers  

---

How can you create an empty table from an existing table?

0 Answers  

---

Can a foreign key be null?

0 Answers  

---

counting the no.of characters occurs in a string by using pl/sql function

1 Answers   TCS,

---

---

What is fmtonly in sql?

0 Answers  

---

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

0 Answers  

---

My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?

2 Answers   CG,

---

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

0 Answers  

---

What are the different sql languages?

0 Answers  

---

how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?

4 Answers   TCS,

---

what are the advantages of package?

7 Answers   iFlex,

---