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 |
Post New Answer View All Answers
what is column? : Sql dba
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
What is data types in sql?
Explian rowid, rownum?
What is vector point function?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What is triggering circuit?
When is the update_statistics command used?
What is mutating error?
What is oracle sql developer?
List out the acid properties and explain?
What are the main features of cursor?
how to write date and time literals? : Sql dba
explain normalization concept? : Sql dba
What is a sql select statement?