How do you know if a relationship is 2nf?

0 Answers  

---

What is materialized view. What are different methods of refresh?

0 Answers  

---

Is progress software supports to ( pl/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 many types of sql are there?

0 Answers  

---

---

What is user in sql?

0 Answers  

---

Does SQL*Plus contains pl/sql Engine?

1 Answers   TCS,

---

Is coalesce faster than isnull?

0 Answers  

---

scope of exception handling in plsql

4 Answers   Wipro,

---

How to select random rows from a table?

0 Answers  

---

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

9 Answers   TCS,

---

i want insert 10 records from table a to table b. if i m using statement level trigger how many record insert ?in row level trigger how many record inserted???

3 Answers   Scope International,

---