Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers   Wipro,

---

How to export the table data (this table having 18 million records) to .csv file. Please tell me is there any faster way to export the data.

8 Answers  

---

Explain architecture of sql server notification services?

0 Answers  

---

what happens if you no create privilege in a database? : Sql dba

0 Answers  

---

how many tupples can insert in 1 second in sql

1 Answers  

---

What do you understand by pl/sql cursors?

0 Answers  

---

How many commands are in sql?

0 Answers  

---

Explain two easy sql optimizations.

0 Answers  

---

What is the difference between local and global temporary table?

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,

---

Write the alter statement to enable all the triggers on the t.students table.

0 Answers  

---

after tell procedure whole code he asked can i write the same way in a function

3 Answers  

---