Skip to content

Instantly share code, notes, and snippets.

@SyedTayyabUlMazhar

SyedTayyabUlMazhar/students.sql

Created October 26, 2019 08:08
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save SyedTayyabUlMazhar/d13704442a734df39322079c53bd7983 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save SyedTayyabUlMazhar/d13704442a734df39322079c53bd7983 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. SyedTayyabUlMazhar created this gist Oct 26, 2019.
    35 changes: 35 additions & 0 deletions students.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,35 @@
    --------------------------------------------------------
    -- File created - Saturday-October-26-2019
    --------------------------------------------------------
    --------------------------------------------------------
    -- DDL for Table STUDENTS
    --------------------------------------------------------

    CREATE TABLE "HR"."STUDENTS"
    ( "ID" NUMBER(*,0),
    "FIRST_NAME" VARCHAR2(50),
    "LAST_NAME" VARCHAR2(50),
    "AGE" NUMBER(*,0),
    "CLASS_NAME" VARCHAR2(20)
    ) ;
    REM INSERTING into HR.STUDENTS
    SET DEFINE OFF;
    Insert into HR.STUDENTS (ID,FIRST_NAME,LAST_NAME,AGE,CLASS_NAME) values (1,'Hasnain','khan',53,'BSCS-4-B');
    Insert into HR.STUDENTS (ID,FIRST_NAME,LAST_NAME,AGE,CLASS_NAME) values (2,'Ahmed','Shakeel',23,'BSCS-4-B');
    Insert into HR.STUDENTS (ID,FIRST_NAME,LAST_NAME,AGE,CLASS_NAME) values (3,'Mohsin','ahmed',19,'BSCS-1-A');
    Insert into HR.STUDENTS (ID,FIRST_NAME,LAST_NAME,AGE,CLASS_NAME) values (4,'Faish','Siddiqui',32,'MCS-2-A');
    --------------------------------------------------------
    -- DDL for Index SYS_C006995
    --------------------------------------------------------

    CREATE UNIQUE INDEX "HR"."SYS_C006995" ON "HR"."STUDENTS" ("ID")
    ;
    --------------------------------------------------------
    -- Constraints for Table STUDENTS
    --------------------------------------------------------

    ALTER TABLE "HR"."STUDENTS" MODIFY ("CLASS_NAME" NOT NULL ENABLE);
    ALTER TABLE "HR"."STUDENTS" MODIFY ("AGE" NOT NULL ENABLE);
    ALTER TABLE "HR"."STUDENTS" MODIFY ("LAST_NAME" NOT NULL ENABLE);
    ALTER TABLE "HR"."STUDENTS" MODIFY ("FIRST_NAME" NOT NULL ENABLE);
    ALTER TABLE "HR"."STUDENTS" ADD PRIMARY KEY ("ID") ENABLE;