what is primary key? : Sql dba

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,

---

suppose we have a table in which 200 rows. i want to find 101 row ? what the query.... and how we find 4th and 5th highest salary and 1 to 10 highest salary

7 Answers  

---

If the base table structure is changed what will happen to join index????

2 Answers  

---

Can a primary key be a foreign key?

0 Answers  

---

---

How can we solve sql error: ora-00904: invalid identifier?

0 Answers  

---

Which is better cte or subquery?

0 Answers  

---

what are null values? : Sql dba

0 Answers  

---

How bulk collect improves performance?

0 Answers  

---

Can we enter data in a table in design view?

0 Answers  

---

How to select random rows from a table?

0 Answers  

---

What is basic structure of pl sql?

0 Answers  

---