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 |
select trunc(round(156.00,-1),-1) from dual;
Can a formula column be obtained through a select statement ?
what is index?
What is the purpose of a cluster?
How to use fetch statement in a loop?
Where are the settings stored for each instance in oracle?
What is the difference between pre-select and pre-query?
what diffrence between function and procedure?
Youre getting high busy buffer waits - how can you find whats causing it?
Explain coalesce function?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
How to execute a stored procedure in oracle?