How many sql statements are used? Define them.

0 Answers  

---

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,

---

What are sql built in functions?

0 Answers  

---

How do I upgrade sql?

0 Answers  

---

What is structural independence and why is it important?

0 Answers  

---

---

write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh

3 Answers   TCS,

---

There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?

4 Answers   IBM,

---

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

0 Answers  

---

What is sql not null constraint?

0 Answers  

---

How to fetch common records from two tables?

1 Answers  

---

Why do we use procedures in pl sql?

0 Answers  

---

How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?

12 Answers   IBM, TCS, UHD,

---