what is the difference between nested subquery and correlated subquery?

0 Answers  

---

what is global variable in package

3 Answers   Polaris,

---

Write a query to find the employees from EMP table those who have joined in Monday. (there is a column as hiredate which is a date column i.e values are like 03-DEC-81)

5 Answers  

---

Mention what are different methods to trace the pl/sql code?

0 Answers  

---

What is difference between select statement and cursor

3 Answers   JDA,

---

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

0 Answers   Microsoft,

---

What are the operators used in select statements?

0 Answers  

---

What is difference between hql and native sql?

0 Answers  

---

how to use like conditions? : Sql dba

0 Answers  

---

How many levels can subqueries be nested in a FROM clause?

7 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  

---

1 SELECT a.field1, b.field2, c.field3, d.field4 2 FROM atable a, atable b, ctable c, dtable d 3 ? 4 ORDER BY 1 What is the minimum number of joins that must be specified on line 3 in the sample code above to properly link the tables? Notice that the table "atable" is aliased twice: once as "a" and once as "b." 1. One join 2. Two joins 3. Three joins 4. Four joins 5. Five joins

6 Answers   Sonata,

---