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

how can I make a script that can be bi-language (supports english, german)? : Sql dba

write a query that returns first characters of each word in Oracel/Sql pl sql

Show the two pl/sql cursor exceptions.

Write the alter statement to enable all the triggers on the t.students table.

What are predefined functions in sql?

after tell procedure whole code he asked can i write the same way in a function

why should required for Indexed by table in pl/sql

What is orm in sql?

How to call the function and Procedure in trigger?

What is a string data type in sql?

how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used

Which are the different character-manipulation functions in sql?

For more SQL PLSQL Interview Questions Click Here