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,

---

How can you fetch first 5 characters of the string?

0 Answers  

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

4 Answers   KPIT,

---

write a query to find 4th max salary

7 Answers  

---

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

3 Answers   JPMorgan Chase,

---

---

Can you alter start with clause?

1 Answers   TCS,

---

what is the difference between truncate and delete statement? : Transact sql

0 Answers  

---

How global cursor can be declare with dynamic trigger ?

0 Answers  

---

What does the file extension accdb stand for?

0 Answers  

---

What is pl/sql table? Why it is used?

0 Answers  

---

What is cursor explain with example?

0 Answers  

---

how to install mysql? : Sql dba

0 Answers  

---