Interested to Buy Any Domain ? << Click Here >> for more details...
how to use sequence and what use of sequence cache
- 1 Answers
- 4394 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 |
How to define a variable of a specific record type?
What are the four Oracle system processes that must always be up and running for the database to be useable?
What is the implicit cursor in oracle?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
does the query needs a hint to access a materialized view?
Preparing for Oracle PL/SQL Interviews – Need Help with Common Questions
How to insert a new row into a table in oracle?
What is the difference between SQL and SQL Server?
Can anyone give me information about oracle certification
What is a proxy class?
Explain the function of optimizer in oracle?
What does `(+)` do in a where clause?
Oracle General 
