What is primary key and foreign key?

0 Answers  

---

how will i became good database developer?

1 Answers  

---

What type of database is sql?

0 Answers  

---

Explain correlated query work?

0 Answers  

---

What is the usage of distinct keyword?

0 Answers  

---

---

Differentiate between % rowtype and type record.

0 Answers  

---

difference between pl/sql table and normal pl/sql table

2 Answers  

---

What is dcl in sql?

0 Answers  

---

Which one is the Best approach to put code, among Triggers and Procedures? Explain?

1 Answers   Sierra Atlantica,

---

Is it possible to use LONG columns in WHERE clause or ORDER BY?

3 Answers  

---

Why use stored procedures?

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,

---