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

How to write numeric literals in oracle?

931


How oracle handles dead locks?

838


I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2242


What is an index associated with a constraint?

804


Explain integrity constraints?

896


> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?

1834


Why cursor variables are easier to use than cursors?

813


Explain the use of parfile option in exp command.

783


Please explain oracle left join with an example?

803


What is the exact use of Collections?

1932


Which is faster join or subquery in oracle?

757


What are the uses of linked server and explain it in detail?

842


How can you merge two tables in oracle?

775


What is a trigger oracle?

830


how may join possible between (requisition with purchase order)

1978