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
How to write numeric literals in oracle?
How oracle handles dead locks?
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?
What is an index associated with a constraint?
Explain integrity constraints?
> 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?
Why cursor variables are easier to use than cursors?
Explain the use of parfile option in exp command.
Please explain oracle left join with an example?
What is the exact use of Collections?
Which is faster join or subquery in oracle?
What are the uses of linked server and explain it in detail?
How can you merge two tables in oracle?
What is a trigger oracle?
how may join possible between (requisition with purchase order)
