A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.

2 Answers   TCS,

---

does sql support programming? : Sql dba

0 Answers  

---

Is mariadb nosql?

0 Answers  

---

what is a database transaction? : Sql dba

0 Answers  

---

Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.

5 Answers   CGI,

---

PL/SQL allocates memory for the variable's at runtime or at compile time

3 Answers  

---

What is a trigger in pl/sql?

1 Answers  

---

What does closing a cursor do?

0 Answers  

---

Cite the differences between execution of triggers and stored procedures?

0 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,

---

how can we destroy the session, how can we unset the variable of a session? : Sql dba

0 Answers  

---

What is Difference Between delete and Truncate?

9 Answers  

---