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 are character functions?

0 Answers  

---

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,

---

What is the differnce between view and materialized view

4 Answers   TCS,

---

How many columns should be in an index?

0 Answers  

---

---

Is sql a backend language?

0 Answers  

---

Difference between DBMS and RDBMS...CODD's rules

4 Answers   Polaris,

---

what is a cursor

9 Answers   IBM, TCS, Wipro,

---

how many columns can be used for creating index? : Sql dba

0 Answers  

---

What is the usage of distinct keyword?

0 Answers  

---

Delete duplicate records in the emp table.

6 Answers   Oracle,

---

Is pl sql different from sql?

0 Answers  

---