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
what do you understand by enhanced entity-relationship


Consider the following database schema: STAFF(StaffNo, fName, lName, Position, sex, dob, branchNo) BRANCH(BranchNo, Street, City) Assume the following for the above database

Creating views with Replace option : This option is used to alter the definition of the view without recreating and dropping it or regranting object privileges previously granted o

Describe disk manager and their work? Disk Manager: Responsible for fetching data regulated through file Manager from disk storage within Main memory and deciding what data to

1.  Develop a flowchart using the decision structure to solve the following problem. A Box Lunch Bonanza is a small catering company that offers 2 different types of box lunches

Mention the type of constraints we can specify in the CREATE command of DDL. The type of constraints that can be specified are as follows:- PRIMARY KEY, NOT NULL, UNIQUE, FOR

Consider the following relational schema: PERSON (SS#, NAME, ADDRESS) CAR (REGISTRATION_NUMBER, YEAR, MODEL) ACCIDENT (DATE, DRIVER, CAR_REG_NO) OWNS (SS#, LICENSE) Constru

Explain the Dynamic Hashing Techniques There are two methods in it: extendible hashing - stores an access structure in addition to the file, and therefore is somewhat identica

A database for the Service and Maintenance (SM) section of a Computer sales and service Company has to be developed. SM gives after sales service to customers. SM branch has a numb