What does “select count(1) from tab” result?

10 Answers   IBM,

---

difference between cursor and procedure in a package

3 Answers   PCS,

---

Which data dictionary views have the information on the triggers that are available in the database?

0 Answers  

---

How packaged procedures and functions are called from the following?

2 Answers  

---

What is clustered and non-clustered indexes?

4 Answers   Microsoft,

---

---

What is the difference between SQL and PLSQL

4 Answers   IBM,

---

how can we destroy the cookie? : Sql dba

0 Answers  

---

Does sql profiler affect performance?

0 Answers  

---

What are primary key and foreign key and how they work?

0 Answers  

---

Why we use cross join?

0 Answers  

---

declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?

3 Answers   Oracle,

---

Can we interchange parameters in procedure while calling

1 Answers   TCS,

---