Answer / shipra

select rownum seq
, name
, age
from ( select name
, age
from your_table
order by name
)

Answer / naresh

by using nvl function

What does dml mean?

0 Answers  

---

What is the difference between a primary key and a clustered index?

0 Answers  

---

I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

2 Answers   HSBC,

---

What is the function that is used to transfer a pl/sql table log to a database table?

0 Answers  

---

How many types of privileges are available in sql?

0 Answers  

---

can we create index on index?

7 Answers   iFlex, Symphony,

---

what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...

1 Answers   HCL, Satyam,

---

what is global variable in pl/sql

1 Answers  

---

When is the update_statistics command used?

0 Answers  

---

Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 Answers  

---

What is execute immediate?

0 Answers  

---

What is a .db file?

0 Answers  

---