how to use sequence and what use of sequence cache
Answer / 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 |
What is bulk collect in oracle?
What are the predefined tablespaces in a database?
How will you identify oracle database software release?
what is Table ?
What is a package ? What are the advantages of package ?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What is oracle datasource?
Explain integrity constraints?
How do we represent comments in oracle?
What privilege is needed for a user to connect to oracle server?
What is the quickest way to export a table to a flat file?
How to start your 10g xe server from command line?