how to use sequence and what use of sequence cache
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 inner join and outer join?
What is flashback Query ? And Use ?
Define the terms primary key foreign key and also the difference between primary and the unique key
What happens to the data files if a tablespace is dropped?
types of indexes and the rationale behind choosing a particular index for a situation.
What is a shared pool?
What is the difference between "as" and "is" in an oracle stored procedure?
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
What are the different approaches used by Optimizer in choosing an execution plan ?
Difference between pre-select and pre-query
Explain oracle 12c new features for developers?
Find all employees in Dept “Marketing”.