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 |
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
How to create a server parameter file?
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
What is the sid in oracle?
Explain the use of constraints option in exp command.
10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables
How to insert multiple rows with one insert statement in oracle?
Explain enable novalidate constraint.
Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)
am completed mca2011 how get certification in oracle
what is null value?
What privilege is needed for a user to delete rows from tables in another schema?