ars_attentry.txt

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

SQL>  create table ars_attentry
  2  (a_date date not null,a_branch varchar2(15) not null,a_year varchar2(2) not null,a_div number (
1) not null,a_subject varchar2(15) not null,a_batch varchar2(1),a_top varchar2(2),a_attend number(1)
,a_roll number(4) not null,a_tid number(3) not null);

Table created.



 insert into ars_attentry
 values('&date','&a_branch','&a_year',&a_div,'&a_subject','&a_batch
 ','&a_top',&a_attend,&a_roll,&a_tid);