5 Open the script named createmgstablessql thats attached to

5. Open the script named create_mgs_tables.sql that’s attached to HW7. Then, run this script. That should restore the data that’s in the database

Solution

Sequences are used to generate a sequnce of numbers.

to create a sequence below is the syntax

SQL> CREATE Sequence SequenceName;

SQL> CREATE SEQUENCE empno_seq

to run this sequnce open sql terminal and run it.

then it generates the sequencing evey time.

(For the above question I did not find the attachedment so i explain the procedure to run it.)

To drop the sequence use below syntax.

SQL> Drop Sequencename;

then the sequemnce is droped from the database.