What is rownum and rowid?

0 Answers  

---

What is the differnce between view and materialized view

4 Answers   TCS,

---

How to avoid duplicate records in a query?

0 Answers  

---

what is the command line end user interface - mysql? : Sql dba

0 Answers  

---

How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')

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

---

Enlist the characteristics of pl/sql?

0 Answers  

---

When is the explicit cursor used ?

0 Answers  

---

What is nvl function?

4 Answers   Cap Gemini,

---

How do you optimize SQL queries ?

6 Answers   CarrizalSoft Technologies, Infosys, Oracle,

---

Is primary key a clustered index?

0 Answers  

---

How show all rows in sql?

0 Answers  

---