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 |
Which is faster view or stored procedure?
Can a commit statement be executed as part of a trigger?
What is a boolean in sql?
What is sql partition function?
Types of joins?
can i call procedure in package
What does the sign mean in sql?
What are hotfixes and patches?
Can one improve the performance of sql*loader? : aql loader
What are conditional predicates?
If records are inserted into table without committing.How to refer to these values in a procedure?
How many types of triggers exist in pl/sql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)