What is the use of sql trace?

0 Answers  

---

take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...

9 Answers   Zensar,

---

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 pl/sql language case sensitive?

0 Answers  

---

What are sql constraints?

0 Answers  

---

How many types of index are there?

0 Answers  

---

What is triggering circuit?

0 Answers  

---

In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?

4 Answers   Tech Soft,

---

What is the difference between delete and truncate commands?

0 Answers  

---

What is data modelling in sql?

0 Answers  

---

What is the starting oracle error number? What is meant by forward declaration in functions?

0 Answers  

---

What is out parameter used for eventhough return statement can also be used in pl/sql?

0 Answers  

---