how to unbreak sequence numbers during intereptions
Answer / sudipta santra
ADDING THE CYCLE KEYWORD.
ALTER SEQUENCE SQ1 CYCLE;
Is This Answer Correct ? | 3 Yes | 0 No |
When system tablespace is created?
what is main def between plsql/table and array?
Explain the use of Merge statement in oracle 11g
Where is the export dump file located?
What is different bet native dynamic sql and Dbms_Sql?
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]
What is meant by recursive hints ?
Point out the difference between user tables and data dictionary?
Explain oracle’s system global area (sga).
select trunc(round(156.00,-1),-1) from dual;
Why packages are used in oracle?