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
Example : Create a sequence named SEQSS that starts at 105, has a step of 1 and can take maximum value as 2000.  CREATE SEQUENCE SEQSS START WITH 105 INCREMENT BY 1 MAX VA

Your friend owns a computer store in Yuen Long, selling Desktop and Notebook PCs and other computer peripherals. Having been rather successful with his business there, he decided t

define anomalies and different types of anomalies with example


Explain the term High level DML? High level DML A high-level or non-procedural DML permit the user to specify what data is needed without specifying how it is to be acquired.

A database is to be constructed to remain track of the teams and games of a sport league. A team has a number of players, not all of whom participate in every game. It is desired

Which database object does not physically exist? A view database object does not physically exist.

Desirable Properties Of Decomposition Decomposition is a process of dividing a relation into its projections that will not be disjoint. Please remind the Relational projection

Q.  What is relational algebra and calculus? Explain the relational algebra operators :- Selection and predicate, set operation, joins and division. Sol. Relational Algebra

What is primary Key Explain? Primary Key - Primary key is one of the candidate keys. It should be selected such in which its attribute values are never, or very rarely, chang