Информатика и выч. техника \ Теория экономических информационных систем

Решения практических упражнений дисциплины "Теория экономических информационных систем", страница 7

Server: Msg 208, Level 16, State 1, Line 1

Invalid object name 'USER_CONSTRAINTS'.

Решения упражнений: урок 13

     CREATE TABLE   СС2

     AS

            SELECT         *

            FROM             COMPANY_CARS ;

Server: Msg 208, Level 16, State 1, Line 1

Incorrect syntax near the keyword 'AS'.

     SELECT     CONSTRAINT_NAME,

                        CONSTRAINT_TYPE,

                        SEARCH_CONDITION

     FROM        USER_CONSTRAINTS

     WHERE     TABLE_NAME = ' СС2 ' ;

Результат:

Invalid object name 'USER_CONSTRAINTS'.

      ALTER TABLE СС2

      ADD

      (CONSTRAINT CC2_CH_NO_PK

                    PRIMARY KEY (CHASSIS_NUMBER) )

                    ENABLE PRIMARY KEY;

Результат:

Server: Msg 170, Level 15, State 1, Line 3

Line 3: Incorrect syntax near '('.

      SELECT               OBJECT_NAME, OBJECT_TYPE

      FROM                   USER_OBJECTS

      ORDER BY           OBJECT_TYPE;

Результат:

Server: Msg 208, Level 16, State 1, Line 1

Invalid object name 'USER_OBJECTS'.

      ALTER TABLE     COMPANY_CARS

      ADD                      (COMMENTS LONG) ;

Результат:

Server: Msg 170, Level 15, State 1, Line 2

Line 2: Incorrect syntax near '('.

      ALTER TABLE COMPANY_CARS

      MODIFY               (MAKE VARCHAR2 (25));

Результат:

Server: Msg 170, Level 15, State 1, Line 2

Line 2: Incorrect syntax near '('.

Решения упражнений: урок 14

SELECT *

FROM EMP

WHERE ENAME = 'SMITH'

Результат:

Без ошибок

SELECT REG_NO,

CHASSIS_NUMBER

FROM COMPANY_CARS

WHERE DOR = '01-JAN-94'

Результат:

Без ошибок

SELECT  *

FROM EMP

WHERE EMPNO = 7902

Результат:

Без ошибок

SELECT ENAME, DNAME

FROM EMP, DEPT

WHERE EMP.DEPTNO =

DEPT.DEPTNO

Результат:

Без ошибок

      CREATE INDEX               CC_DEPTNO_FK

      ON                                    COMPANY_CARS (DEPTNO) ;

      Index created.

      CREATE INDEX               CC_EMPNO_FK

      ON                                    COMPANY_CARS (EMPNO) ;

      Index created.

Результат:

Без ошибок

     CREATE INDEX                CC_MODEL_INDEX

     ON                                                 COMPANY_CARS (MODEL) ;

Результат:

Без ошибок

      SELECT                INDEX_NAME, TABLE_NAME, UNIQUENESS

      FROM                   USER_INDEXES

      WHERE                TABLE_NAME = 'COMPANY_CARS';

Результат:

Server: Msg 208, Level 16, State 1, Line 1

Invalid object name 'USER_INDEXES'.

Решения упражнений: урок 15

       CREATE SEQUENCE    CC_SEQUENCE

       START WITH                  1

       INCREMENT BY             1

       MAXVALUE                     5;

Результат:

Server: Msg 170, Level 15, State 1, Line 1

Line 1: Incorrect syntax near 'SEQUENCE'.

       SELECT              SEQUENCE_NAME

       FROM                  USER_SEQUENCES;

Результат:

Server: Msg 208, Level 16, State 1, Line 1

Invalid object name 'USER_SEQUENCES'.

Решения упражнений: урок 16

        CREATE VIEW CC_VIEW

        AS

        SELECT             CHASSIS_NUMBER,

                                    REG_NO,

                                    EMPNO,

                                    DEPTNO

        FROM                 COMPANY_CARS ;

Результат:

Без ошибок

Select * from cc_view

Результат:

Без ошибок

        CREATE             VIEW AGGREGATES
                                    (DEPTNO, AVERAGE, MAXIMUM,
                                   MINIMUM, SUM, NO_SALS, NO_COMMS)
        AS

        SELECT             DEPTNO,
                                   AVG (SAL),
                                   MAX (SAL),
                                   MIN (SAL),
                                   SUM (SAL),
                                   COUNT (SAL),
                                   COUNT (COMM)
        FROM                 EMP
        GROUP BY        DEPTNO;

Скачать файл