What are variables in pl sql?

0 Answers  

---

what is 'force view'?

3 Answers   Cap Gemini, SPIC,

---

1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.

1 Answers   Polaris,

---

What is crud sql?

0 Answers  

---

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

0 Answers   Virtusa,

---

---

If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 Answers  

---

How can we store rows in PL/SQL using array?

0 Answers   MCN Solutions,

---

Explain the steps needed to create the scheduled job?

0 Answers  

---

I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?

8 Answers   L&T,

---

What are hotfixes and patches?

0 Answers  

---

Can pl sql procedure have a return statement?

0 Answers  

---

what command is used to create a table by copying the structure of another table including constraints ?

6 Answers   CMC, eicc,

---