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 does dml mean?
What is the difference between a primary key and a clustered index?
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?
What is the function that is used to transfer a pl/sql table log to a database table?
How many types of privileges are available in sql?
can we create index on index?
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...
what is global variable in pl/sql
When is the update_statistics command used?
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...
What is execute immediate?
What is a .db file?
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)