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
How to loop through a cursor variable?
What is the relation of a user account and a schema?
How to select some columns from a table in oracle?
What is the parameter mode that can be passed to a procedure?
What are the arithmetic operations?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
What is blob datatype?
How to define a data source name (dsn) in odbc manager?
How to get execution path reports on query statements?
Explain compound trigger in oracle?
What operating systems are supported by oracle database 10g xe?
What is transaction control statement and how many types of transaction control statement in Oracle?
What do you mean by cdb and pdb in oracle 12c?
What is a cursor in oracle?
How do I limit the number of rows returned by an oracle query after ordering?
