students.sql

--------------------------------------------------------
--  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;