how to create temparary sequence
Answers were Sorted based on User's Feedback
Answer / shipra
select rownum seq
, name
, age
from ( select name
, age
from your_table
order by name
)
Is This Answer Correct ? | 3 Yes | 0 No |
What are sql commands?
Do we need to create index on primary key?
What are different types of indexes?
Sql technical questions
what is a cursor? : Sql dba
What is difference between my sql and sql?
What is union and union all keyword in sql?
How can I delete duplicate rows?
How to convert comma separated string to array in pl/sql?
How many row comparison operators are used while working with a subquery?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
What is oracle and pl sql?