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 access the current value and next value from a
sequence?

Answer Posted / chandrasekar ramasamy

select sequencename.currval from tablename

select sequencename.nextval from tablename

Is This Answer Correct ?    8 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we rollback delete command?

984


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

1125


What is varchar example?

1029


Explain raise_application_error.

1094


What are the different parts of a package?

1115


how to include character strings in sql statements? : Sql dba

1071


What is the difference between alter trigger and drop trigger statements?

1109


How can you load microsoft excel data into oracle? : aql loader

1174


what does myisamchk do? : Sql dba

1018


Is pl sql different from sql?

998


what are date and time functions in mysql? : Sql dba

979


How to use boolean type in select statement?

1073


What is the difference between subquery and correlated query?

1065


Can we perform dml in function?

1067


What is 19 null in sql?

965