how to use sequence and what use of sequence cache
- 1 Answers
- 4074 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 the uses of cusor
What is bind variable in oracle 11g?
What is currency type in database ?
Define Normalization with example?
What are a collation and state the different types of collation sensitivity?
Display Odd/ Even number of records?
What are the uses of Rollback Segment ?
Where are the settings stored for each instance in oracle?
What are the logical operations?
You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?
i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint type" this code must be in string type please help me if you want, i can give more explainings
can we pass two out parameters at a time in function?please answer to my question
Oracle General 
