how to create temparary sequence

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 can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

0 Answers  


What is posting?

0 Answers  


Does mysql_real_escape_string prevent sql injection?

0 Answers  


what is the difference between nested subquery and correlated subquery?

0 Answers  


How many types of indexes are there in sql?

0 Answers  






How many types of normalization are there?

0 Answers  


What does count (*) mean in sql?

0 Answers  


using cursors salesman get bonus as 10% of their salary , managers get 20% , analalist get 30%. generae a report showing the employee name, salary , bonus.

4 Answers   Fidelity,


Why do we need unique key in a table?

0 Answers  


What are the two parts of design view?

0 Answers  


Explain the commit statement.

0 Answers  


what is column? : Sql dba

0 Answers  


Categories