Oracle SQL INSERT Example

INSERT - Row

Insert a row of data. Note: the minimum requirements for and insert must include columns that are part of the primary key, part of indexes where no duplicates are allowed, and all columns that cannot be null.

INSERT INTO COURSES
     (
        COURSE_DESIGNATER           ,
        COURSE_NAME                 ,
        EDUCATION_DELIVERY_METHOD   ,
        COURSE_DESCRIPTION_SHORT    ,
        COURSE_DESCRIPTION_LONG     ,
        COURSE_SYLLABUS_ATTACHMENT  ,
        COURSE_MATERIALS_ZIP        ,
        COURSE_MATERIALS_LOCATION   ,
        MAX_RECOMMENDED_ENROLLMENT  ,
        CONVENINGS                  ,
        CONVENINGS_DETAILS          ,
        CONVENINGS_CONSECUTIVE_FLG  ,
        TYPICAL_PRECLASS_PREP_TIME  ,
        TYPICAL_POSTCLASS_PREP_TIME ,
        TYPICAL_CONVENING_TIME      ,
        SPONSER_NAME                ,
        ACTIVE_FLG                  ,
        INACTIVE_DATE               ,
        INACTIVE_REASON             ,
        EMPLOYEE_INACTIVATING       
     ) 
VALUES
     (
        'SQL200' , 
        'Intermediate SQL' , 
        'Classroom' , 
        NULL , 
        NULL , 
        'doc' , 
        'zip' , 
        'DataExpressions\csematerials' , 
        16 , 
        0 , 
        NULL , 
        0 , 
        NULL , 
        NULL , 
        NULL , 
        NULL , 
        1 , 
        NULL , 
        NULL , 
        0 
     ) 
/

COMMIT WORK ;

 Collapse All    Expand All
Custom Search

Oracle Information and Resources