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

Explain a segment?

0 Answers  


How to delete a column in an existing table in oracle?

0 Answers  


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)

4 Answers   Infosys,


What is the implicit cursor in oracle?

0 Answers  


Explain can a view based on another view?

1 Answers  


how to delete all duplicate records from a table using subquery?

7 Answers   ABC, Cap Gemini,


Explain oracle left join with an example?

0 Answers  


how do get database name at sql prompt?

3 Answers  


How to set up autotrace for a user account?

0 Answers  


How do I start tns listener?

0 Answers  


does Oracle has only one table space?

1 Answers   Oracle,


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • 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)