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
What is oracle thin client?
What is oracle database client?
What is a server parameter file in oracle?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
Explain what are the type of synonyms?
How to convert a date to char in oracle? Give one example.
What is an oracle data file?
What is a user account in oracle?
What are dml statements in oracle?
How to call a stored function with parameters?
What is the difference between I and G in Oracle?
What is bulk load in oracle?
What is connection pool in oracle?
What is the difference between Delete, Truncate and Drop in Oracle?
How to invoke the data pump import utility?