CREATE TABLE "c##project"."EMPLOYEE"  ( 
	"ID"         	VARCHAR2(4) NOT NULL,
	"FIRST_NAME" 	VARCHAR2(10) NULL,
	"LAST_NAME"  	VARCHAR2(10) NULL,
	"START_DATE" 	DATE NULL,
	"END_DATE"   	DATE NULL,
	"SALARY"     	NUMBER(8,2) NULL,
	"CITY"       	VARCHAR2(10) NULL,
	"DESCRIPTION"	VARCHAR2(15) NULL 
	)
GO


CREATE SEQUENCE "c##project"."STUDENT_SEQUENCE"
	INCREMENT BY 1
	START WITH 1
	MAXVALUE 999999999999999999999999999
	NOMINVALUE
	CYCLE
	CACHE 20
	ORDER
	KEEP
	SESSION
GO
CREATE OR REPLACE PROCEDURE "c##project"."ADDNEWEMPLOYEE1" (
    "P_FIRSTNAME"  "EMPLOYEE"."FIRST_NAME"%TYPE,
    "P_LASTNAME"   "EMPLOYEE"."LAST_NAME"%TYPE,
     "P_SALARY"      "EMPLOYEE"."SALARY"%TYPE) IS
  BEGIN
     INSERT INTO "c##project"."EMPLOYEE" ("ID", "FIRST_NAME", "LAST_NAME",
                          "SALARY")
       VALUES ("STUDENT_SEQUENCE"."NEXTVAL", "P_FIRSTNAME", "P_LASTNAME",
              "P_SALARY");

  END "ADDNEWEMPLOYEE1" ;