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
How to create a biological database based on viruses. How to decide which attribute should be there in the table and schema? How to identify the primary keys, foreign keys, domain,

Discuss the term- Design Optimization  We have seen various ways of representing the objects.The fundamental design model uses analysis model as the framework for implementati

Vertical Fragmentation- Vertical fragmentation groups together only those attributes in a relation that are used jointly by various important transactions. A vertical fragment is d

Creating views with Read only option : In the view definition this option is used to make sure that no DML operations can be done on the view.

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

Primary index A primary index is a file that has a sorted series of records having two columns: a block address for that key field in the data file; and the ordering key field.

Question 1 What is data mining? Write Data Mining applications Question 2 What is OLAP? Write the benefits of OLAP Question 3 What is Business Intelligence? Explai

Describe integrity and security? a)      Domain constraint b)      Referential integrity A value that appears in one relation for a given set of attributes also appear fo

A Distributed Transaction Let us demonstrate the concept of a distributed transaction by considering a banking system having of three branches located in 3 different cities. Ev

What is catalog in DBMS? Catalog - A relational DBMS maintains information about every table and index in which it contains. A catalog is a collection of special tables that st