How do I install sql?

0 Answers  

---

How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , for ex: A is the main project id, for this project B,C,D are sub tasks(sub project id's) for B the sub tasks are e,f,g and for c is h ,i ,j and for d is k,l,m now i need to display the o/p in a TREE fashion pls help me , thanks in advance surendra

2 Answers   Zensar,

---

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy

6 Answers   Target,

---

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,

---

What is trigger in sql? Explain

0 Answers  

---

Can cursors be part of a trigger body?

0 Answers  

---

What is the use of %rowtype?

0 Answers  

---

What packages(if any) has oracle provided for use by developers?

1 Answers  

---

Types of joins ?

11 Answers   Polaris, TCS,

---

What are data types in pl sql?

0 Answers  

---

Where the sql database files are stored?

0 Answers  

---

what is query cache in mysql? : Sql dba

0 Answers  

---