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 store only time in a data base table
What is enter substitution variable in oracle?
How to get a list of all user accounts in the database?
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit
without using count(*) and rownum how can we count total record in a table
How to unlock the sample user account in oracle?
How to use windows user to connect to the server?
What is the sql query to concatenate column values from multiple rows in oracle?
what are the different types of cursors? explain?
what r tyhe major differences between oracle 9i & 10g?
What is a sub query? Describe its types?
How do I learn what codesets are available in oracle?