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 |
How to define a specific record type?
Is there a function to split a string in plsql?
How to export several tables together?
what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.
Explain how you would restore a database using RMAN to Point in Time?
What do you understand by database schema and what does it hold?
how many types of index?
What is the quickest way to fetch the data from a table?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
How would you go about verifying the network name that the local_listener is currently using?
How do you bind variables in oracle?
what is primary key?