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?

2 Answers  

---

Write a sql query to find the names of employees that begin with ‘a’?

0 Answers  

---

How many LONG columns are allowed in a table?

6 Answers   CTS,

---

Is left join and outer join same?

0 Answers  

---

What is rank () in sql?

0 Answers  

---

I need a function for a train ticket reservation please answer it thanks in advance

0 Answers  

---

what is the purpose of update command in oracle?

7 Answers   MBT,

---

Why having clause is used in sql?

0 Answers  

---

what are the tunnig tables you used for tuning a query and tell me some of coloumns in that tuning tables?

1 Answers   Metric Stream,

---

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,

---

What has stored procedures in sql?

0 Answers  

---

What does pl sql developer do?

0 Answers  

---