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...


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

Explain the methods used to protect source code of pl/sql.

0 Answers  


Why we use joins in sql?

0 Answers  


column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

4 Answers  


Why does %isopen return false for an implicit cursor?

1 Answers  


how to get a list of all tables in a database? : Sql dba

0 Answers  


How can triggers be used for the table auditing?

0 Answers  


what are all types of user defined functions? : Sql dba

0 Answers  


ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

2 Answers  


What is numeric function sql?

0 Answers  


How do I order columns in sql?

0 Answers  


What are the advantages of sql? Explain

0 Answers  


how to select unique records from a table? : Sql dba

0 Answers  


Categories