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

Explain alias?

1193


What is enter substitution variable in oracle?

1093


defination of bitmap index

2175


What happens if you set the sga too low in oracle?

1222


What is varray?

1192


What is oracle host variable?

1129


I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2340


How to create an oracle testing table?

1126


How a tablespace is related to data files?

1162


How to define an anonymous procedure without variables?

1187


candidate key is subset of super key but not vice-verse explain

2106


How to use "while" statements in oracle?

1375


How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2305


How to estimate disk space needed for an export job?

1103


What is redo log?

1112