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,

---

What is scalar function?

0 Answers  

---

Is nosql relational?

0 Answers  

---

What is clustered index in sql?

0 Answers  

---

What is a left join?

0 Answers  

---

What are the various restrictions imposed on view in terms of dml?

0 Answers  

---

Can we create index on primary key?

0 Answers  

---

Difference between IN and EXISTS

4 Answers   Nous, Polaris,

---

how view used for security purposes?

3 Answers   Glam India,

---

How does sql developer connect to oracle database?

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,

---

What is pseudo column ?

6 Answers   ABB,

---