What will you get by the cursor attribute sql%rowcount?

0 Answers  

---

using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.

4 Answers   Fidelity,

---

what is primary key? : Sql dba

0 Answers  

---

What are different joins used in sql?

0 Answers  

---

What is a stored procedure in sql with example?

0 Answers  

---

What is data type in database?

0 Answers  

---

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,

---

what is foreign key? : Sql dba

0 Answers  

---

When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?

2 Answers   Accenture, Unisoft Infotech,

---

wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?

4 Answers   Oracle, TCS, Tecnics,

---

What are sql*plus environment variables?

0 Answers  

---

what is rollback? : Sql dba

0 Answers  

---