What is a Sequence ?

Answer Posted / kumar

Sequence is used for number generation.

We can create a sequence and cannot update a sequence
directly.

After creating a sequence we ca use functions nextval,
currval and setval to operate on the sequence.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

4938


Explain the use of control file?

666


What is translate in oracle?

631


How many types of tables are there in oracle?

591


How to load data through external tables?

592






What is meant by an index?

639


What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

1537


What privilege is needed for a user to create indexes in oracle?

584


What is oracle rowcount?

591


How to turn on or off recycle bin for the instance?

621


How is it different from a normal table?

589


What do you mean by a tablespace?

578


How to get a create statement for an existing table?

583


How to drop a tablespace?

584


What is an oracle wallet?

525