Modifyand removing a sequence-sequences, Database Management System

Modify a sequence:

ALTER SEQUENCE SEQSS

INCREMENT 2

MAXVALUE 3000;

 

Removing a sequence:

DROP SEQUENCE SEQSS;

 

 

 

Posted Date: 3/11/2013 2:28:58 AM | Location : United States







Related Discussions:- Modifyand removing a sequence-sequences, Assignment Help, Ask Question on Modifyand removing a sequence-sequences, Get Answer, Expert's Help, Modifyand removing a sequence-sequences Discussions

Write discussion on Modifyand removing a sequence-sequences
Your posts are moderated
Related Questions
Why 'AS' clause is used in SQL ? 'As' clause is used for Rename operation. ‘AS' clause is used in SQL for rename operation. (e.g., SELECT ENO AS EMPLOYEE_NO FROM EMP)

What are the key features of Oracle? Key features of Oracle are as follows: • Read Consistency • Concurrency • Locking Mechanisms • Quiesce Database • RAC • Portability

What is DML compiler? DML Compiler: Translates DML statements in a query language within low level instructions understandable through the query evaluation engine. Attempts to

Set Difference If R1 and R2 are two union compatible relations or relations then result of R3 =R1- R2 is the relation that have only those tuples that are in R1 but not in R2.

Data Handling and Research Methods: The dataset encompassing 130 participants contains several variables measuring detrimental health related behaviours referring to the use o


Describe Interfaces for the DBA? Interfaces for the DBA - Most database systems holds privileged commands which could be used only through the DBA's staff. These involves com

What are the benefits of prepared statements and place holders? Parameter binding operations automatically handle escaping of characters Encourage Statement reuse

What is an index? An index is a structure that helps to place desired records of a relation quickly, without probing all records.

Explain the term- Periodic recomputation Periodic recomputation:  Base values are often updated in bunches. Sometimes, it is possible to just recompute all derived attributes p