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

0 Answers  

---

What are Lexical Parameters.How They are used in Reports 6i

2 Answers   eicc,

---

What are the two virtual tables available at the time of database trigger execution?

0 Answers  

---

What are wait events. Describe the wait event tables.

1 Answers   CTS,

---

What is the non-clustered index in sql?

0 Answers  

---

---

Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ?

7 Answers   PreVator,

---

What is the difference between the implicit and explicit cursors?

0 Answers  

---

Explain commit, rollback and savepoint.

0 Answers  

---

What is embedded sql what are its advantages?

0 Answers  

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

0 Answers  

---

Is pl sql better than sql?

0 Answers  

---

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

---