stud db.txt

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

SQL> create table ARS_STUDENTRY
  2  (SROLLNO NUMBER(4) PRIMARY KEY,SNAME VARCHAR2(20) NOT NULL,SBRANCH VARCHAR2(10) NOT NULL,SYEAR 
VARCHAR2(2) NOT NULL,SDIVISION NUMBER(1) NOT NULL,SADDRESS VARCHAR2(30) NOT NULL,SCONTACTNO NUMBER(1
0));

Table created.

 INSERT INTO ARS_STUDENTRY
 VALUES(&SROLLNO,'&SNAME','&SBRANCH','&SYEAR',&SDIVISION,'&SADDRESS',&SCONTACTNO);