What is prepared statement in sql?

0 Answers  

---

What do you understand by pl/sql packages?

0 Answers  

---

what is the difference between $message and $$message? : Sql dba

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,

---

write a procedure to find top second no from a list of numbers

1 Answers   ABC,

---

How can a pl sql block be executed?

0 Answers  

---

I am creating an index on Emp table Empno column,if u using this indexed column in ur SELECT stmt. where clause,then how do u know that yr index will be working or nor? Thanks Advance...

3 Answers  

---

What is break?

0 Answers  

---

If we have n no of columns in a table, can we add new column in that table with not null constraint?

2 Answers  

---

Will truncate release space?

0 Answers  

---

Write a simple program on cursors

2 Answers   BirlaSoft,

---

What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual

6 Answers   Cap Gemini, TCS,

---