how to use sequence and what use of sequence cache



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

Post New Answer

More Oracle General Interview Questions

How to define a specific record type?

0 Answers  


Is there a function to split a string in plsql?

0 Answers  


How to export several tables together?

0 Answers  


what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.

9 Answers   BPO, Excel, Wipro,


Explain how you would restore a database using RMAN to Point in Time?

0 Answers  






What do you understand by database schema and what does it hold?

0 Answers  


how many types of index?

2 Answers   Cap Gemini, TCS,


What is the quickest way to fetch the data from a table?

0 Answers  


Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers  


How would you go about verifying the network name that the local_listener is currently using?

0 Answers  


How do you bind variables in oracle?

0 Answers  


what is primary key?

9 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)