Interested to Buy Any Domain ? << Click Here >> for more details...
how to use sequence and what use of sequence cache
- 1 Answers
- 4545 Views
- I also Faced
- E-Mail Answers
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 are set operators?
What are the different editions of oracle?
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.
Explain oracle data types with examples?
What is SAVE POINT ?
What is Library Cache in Oracle?
master table and child table performances and comparisons in Oracle ?
Explain the use of tables option in exp command.
What is tns service name?
How to insert multiple rows with one insert statement in oracle?
Why is oracle so popular?
How to delete all rows a table in oracle?
Oracle General 
