how to create temparary sequence

Question Posted / naresh

Answers were Sorted based on User's Feedback

how to create temparary sequence ..

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

how to create temparary sequence ..

Answer / naresh

by using nvl function

Is This Answer Correct ?

8 Yes

10 No

More SQL PLSQL Interview Questions

What are the possible values that can be stored in a boolean data field?

How many LONG columns are allowed in a table?

What mean sql?

What are different types of statements supported by sql?

What is the difference between explicit and implicit cursors in oracle?

Why is %isopen always false for an implicit cursor?

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

what's the difference between a primary key and a unique key? : Sql dba

What are Nested Tables? How will u delete 5 rows from Nested Tables

how u can find the n row from a table?

Name the operator which is used in the query for pattern matching?

explain the difference between delete , truncate and drop commands? : Sql dba

For more SQL PLSQL Interview Questions Click Here