Interested to Buy Any Domain ? << Click Here >> for more details...
how to use sequence and what use of sequence cache
- 1 Answers
- 4489 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 is oracle data type?
How to connect to a remote server?
Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??
what is the bitmap index?
Is oracle an operator?
Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.
How to use "out" parameter properly?
What is a procedure in oracle?
What is not equal to in oracle?
What is catalog in Oracle?
Explain a data segment?
What is self-referential integrity constraint ?
Oracle General 
