Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

What is row_number () in sql?

0 Answers  

what eliminate duplicate without using roenum and not

5 Answers   Matrix,

Can we change the table name in sql?

0 Answers  

How show all rows in sql?

0 Answers  

What trigger means?

0 Answers  

what is the cursor and use of cursor in pl/sql ?

4 Answers  

How to display all Friday's in a year with date?

4 Answers   Flipkart,

What is the difference between inner join and left join?

0 Answers  

suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how we will do..?

6 Answers  

how to check myisam tables for errors? : Sql dba

0 Answers  

How do I clear the screen in sql plus?

0 Answers  

What are the different types of sql commands?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories