How to add new employee details in an employee_details table with the following details

0 Answers  

---

how to create a primary key with out creating an index?

9 Answers   TCS,

---

What do you mean by query optimization?

0 Answers  

---

How do you update sql?

0 Answers  

---

How do you select unique values in sql?

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,

---

how do u call in & out parameters for stored procedures?

10 Answers   A1 Technology, TCS, Techicon,

---

How can we optimize a sql query?

0 Answers  

---

What is the difference between an inner join and an outer join?

0 Answers  

---

How to look at the current sql*plus system settings?

0 Answers  

---

i need department wise top 2 employees salary.which logic i will use

17 Answers  

---

Are subqueries better than joins?

0 Answers  

---