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 a procedure in oracle?
What is a system tablespace?
Is it possible to insert comments into sql statements return in the data model editor ?
What is a database table in oracle?
What is save point in oracle database?
What is procedure overloading in oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
Explain coalesce function?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is oracle data type?
What are the uses of a database trigger?
How many data types are supported?
what is the use of system.effective.date variable in oracle?
Explain the function of optimizer in oracle?
Is there a function to split a string in plsql?
