teah db.txt

来自「Attendance Report System of student in V」· 文本 代码 · 共 9 行

 CREATE TABLE ARS_TEACHENTRY
      (TID NUMBER(3) PRIMARY KEY,TPASSWORD VARCHAR2(10) NOT NULL,TBRANCH VARCHAR2(10) NOT NULL,TYEAR VARCHAR2(2) NOT NULL,TDIVISION
  NUMBER(1) NOT NULL,TSUBJECT VARCHAR2(15) NOT NULL,TTHEORY NUMBER(1) NOT NULL,TPRACTICAL NUMBER(1) 
NOT NULL,TBATCH VARCHAR2(1),TNAME VARCHAR2(20) NOT NULL);

INSERT INTO ARS_TEACHENTRY
VALUES(&TID,'&TPASSWORD','&TBRANCH','&TYEAR',&TDIVISION,'&TSUBJECT',&TTHEORY,&TPRACTICAL,'&TBATCH','&TNAME')