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
Farmer Bob, Farmer Jane and Farmer Jose run a cow farming co-op. For every cow they keep the cow’s name, age (or date of birth), breed and numbered plastic ear tag. The each of t

Which product produces the relation that has attributes of R1 and R2 ? Cartesian product produce the relation which has attributes of R1 and R2

How nulls are treated in comparison operator? Along with comparison (relational) operators, the null values are ignored as we cannot derive the relation along with the given op

Define query optimization. Query optimization refers to the process of search the lowest -cost method of evaluating a given query.

What are the basic objects of the data dictionary? Tables Domains Data elements Structures Foreign Keys

Insertion Anomaly: Inability to show certain information-The primary key of the over relation be (enrolment number, Cno). Any new tuple to be inserted in the relation should have

Two-way Associations Mostly, associations are travel in both directions, although not usually with same frequency. There are three approaches for the implementation. In

Determine the language that needs a user to specify the data to be retrieved with no specifying exactly how to get it is Ans: Non-Procedural DML

It defines that the tuple in one relation that refers to another relation must refer to an existing tuple in that relation. This constraint is states on two relations (not essentia

Differentiate between logical database design and physical database design. Show how this separation leads to data independence? Basis Logical Databas