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 / saty

select sequencename.currval from dual

select sequencename.nextval from dual



if we will give only table name thr will be error


Thanks & regards
satya
+919916174212

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is a foreign key always unique?

943


How does pl sql work?

965


how to get help information from the server? : Sql dba

942


Is sqlite thread safe?

1054


how to create a new table by selecting rows from another table in mysql? : Sql dba

1107


explain mysql aggregate functions. : Sql dba

993


How to take user input in pl sql?

1164


What is the difference between sql and t sql?

1036


What is case function?

1042


Can we perform dml in function?

1068


how to include comments in sql statements? : Sql dba

959


What is pl sql package?

1034


What is the most common sql injection tool?

1042


What is blind sql injection?

1074


List the different type of joins?

1061