Database Objects in DBMS

CREATE TABLE [schema.]table
               (column datatype [DEFAULT expr][, ...]);

CREATE TABLE dept
           (deptno NUMBER(2),
            dname VARCHAR2(14),
            loc VARCHAR2(13));

DESCRIBE dept;

CREATE [OR REPLACE] [FORCE|NOFORCE] VIEW view
                       [(alias[, alias]...)]
                       AS subquery
                       [WITH CHECK OPTION [CONSTRAINT constraint]]
                       [WITH READ ONLY [CONSTRAINT constraint]];

CREATE VIEW salvu50
               AS SELECT employee_id ID_NUMBER, last_name NAME,
               salary*12 ANN_SALARY
               FROM employees
               WHERE department_id = 50;

SELECT *
FROM salvu50;

CREATE SEQUENCE sequence
                    [INCREMENT BY n]
                    [START WITH n]
                    [{MAXVALUE n | NOMAXVALUE}]
                    [{MINVALUE n | NOMINVALUE}]
                    [{CYCLE | NOCYCLE}]
                    [{CACHE n | NOCACHE}];

CREATE SEQUENCE dept_deptid_seq
                        INCREMENT BY 10
                        START WITH 120
                        MAXVALUE 9999
                        NOCACHE
                        NOCYCLE;

SELECT sequence_name, min_value, max_value,
                       increment_by, last_number
                       FROM   user_sequences;

CREATE INDEX index
            ON table (column[, column]...);

CREATE INDEX emp_last_name_idx
                ON  employees(last_name);

CREATE [PUBLIC] SYNONYM synonym FOR  object;

CREATE SYNONYM d_sum FOR dept_sum_vu;