what is an extent ? : Sql dba

0 Answers  

---

What do you understand by exception handling in pl/sql?

0 Answers  

---

what is commit? : Sql dba

0 Answers  

---

How do you remove duplicate records from a table?

0 Answers  

---

what are the advantages of mysql in comparison to oracle? : Sql dba

0 Answers  

---

---

What are aggregate functions in sql?

0 Answers  

---

How would you pass hints to the sql processor?

0 Answers  

---

What are the Restrictions on Cursor Variables?

2 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,

---

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 bcp? When does it used? : Sql dba

0 Answers  

---

How can we find duplicate records in a table?

0 Answers  

---