select rownum seq , name , age from ( select name

how to create temparary sequence

Question Posted / shipra

Answer Posted / shipra

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

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is sql query optimization?

1089

what is error ora-03113: end-of-file on communication channel?

1149

Can we use pl sql in sql server?

1063

What is faster join or subquery?

998

What is normalization sql?

1039

What is your daily office routine?

2256

How to display the records between two range in Oracle SQL Plus?

1134

How many sql statements are used?

1000

What normalization means?

950

What are sql data types?

998

What is the use of function in sql?

1069

What is a unique key and primary key and foreign key?

955

Why do we need view in sql?

968

Is it possible to update views?

946

What are string functions in sql?

1219