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 |
Explain a segment?
How to delete a column in an existing table in oracle?
Whatz the main diff between Subquery and a Join
14 Answers Oracle, Zeta Interactive,
Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)
What is the implicit cursor in oracle?
Explain can a view based on another view?
how to delete all duplicate records from a table using subquery?
Explain oracle left join with an example?
how do get database name at sql prompt?
How to set up autotrace for a user account?
How do I start tns listener?
does Oracle has only one table space?