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 use sequence and what use of sequence cache

Answer Posted / pravin

sequence is sharable object in database which is use to
generate unique number
use of sequence is like
insert into table(emp_id,name)values
(sequencname.nextvalue,name)
&
cache is the memory use to how manu values preallocates in
memory & keep in memory defined in cache.
by default 20 values can be stored in cache.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oracle thin client?

1019


What is oracle database client?

1024


What is a server parameter file in oracle?

1044


What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1098


Explain what are the type of synonyms?

1103


How to convert a date to char in oracle? Give one example.

1054


What is an oracle data file?

1096


What is a user account in oracle?

1117


What are dml statements in oracle?

1088


How to call a stored function with parameters?

1027


What is the difference between I and G in Oracle?

1085


What is bulk load in oracle?

1064


What is connection pool in oracle?

981


What is the difference between Delete, Truncate and Drop in Oracle?

1122


How to invoke the data pump import utility?

1156