1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Post New Answer

More SQL PLSQL Interview Questions

How do I start sql from command line?

0 Answers  

What is the difference between Union and Union all. Which is faster.

0 Answers  

what is rollback? : Sql dba

0 Answers  

How do I tune a sql query?

0 Answers  

Why do we use function in pl sql?

0 Answers  




Give an example of any procedure.

5 Answers   Accenture, iFlex, Wipro,

Is not null in sql?

0 Answers  

What is break?

0 Answers  

Why left join is used in sql?

0 Answers  

What are pl sql procedures?

0 Answers  

what is view? : Sql dba

0 Answers  

Explain raise_application_error.

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories