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
What is a proxy class?
Can we connect to ORACLE db using Windows Authentication?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
Why do you use stored procedures and state some of its disadvantages?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
How can I create database in oracle?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Is oracle the best database?
Give syntax for SQL and ORACLE joins.
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
what is meant by magic query
What is oracle join syntax?
What are the differences between interval year to month and interval day to second?
Explain user account with reference to oracle.
How to use "in out" parameter properly?
