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
Explain alias?
What is enter substitution variable in oracle?
defination of bitmap index
What happens if you set the sga too low in oracle?
What is varray?
What is oracle host variable?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
How to create an oracle testing table?
How a tablespace is related to data files?
How to define an anonymous procedure without variables?
candidate key is subset of super key but not vice-verse explain
How to use "while" statements in oracle?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
How to estimate disk space needed for an export job?
What is redo log?