Answer Posted / mani

SELECT A+B+C+D FROM
( select
count(decode(A,null,1)) A,
COUNT(DECODE (B,null,1))B,
COUNT(DECODE (C,null,1))C,
COUNT(DECODE(D,null,1)) D
from PRACTICE2);

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 ?

1029

---

What are sql queries used for?

1023

---

How can you load microsoft excel data into oracle? : aql loader

1174

---

What is the difference between null value, zero, and blank space?

1204

---

What is consistency?

1122

---

Why cross join is used?

1076

---

What are local and global variables and their differences?

1090

---

What are the possible values that can be stored in a boolean data field?

1000

---

What is meant by truncate in sql?

1068

---

what is 'mysqladmin' in mysql? : Sql dba

1025

---

What is java sql drivermanager?

1093

---

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

4014

---

what are myisam tables? : Sql dba

1032

---

what is cursor. write example of it. What are the attributes of cursor.

1391

---

Explain the steps needed to create the scheduled job?

1038

---