SQL> create table testable(recordnumber int,currentdate date);Table created.SQL> set serveroutput onSQL> declare 2 2 maxrecords constand int:=100; 3 3 i int:=1; 4 4 begin 5 5 for i in 1..maxrecords loop 6 insert into testable(recordnumber,currentdate) 7 values(i,sysdate); 8 end loop; 9 dbms_output_line('ksdfnkdskfah'); 10 commit; 11 end;SQL> / 2 maxrecords constand int:=100; * ERROR at line 2: ORA-06550: line 2, column 3: PLS-00103: Encountered the symbol "2" when expecting one of the following: begin function package pragma procedure subtype type use <an identifier> <a double-quoted delimited-identifier> form current cursor SQL> 出现上述问题,我该如何解决?请赐教。。谢谢。
2 2 maxrecords constand int:=100;
3 3 i int:=1;
4 4 begin
5 5 for i in 1..maxrecords loop
6 insert into testable(recordnumber,currentdate)
7 values(i,sysdate);
8 end loop;
9 dbms_output_line('ksdfnkdskfah');
10 commit;
11 end;SQL> /
2 maxrecords constand int:=100;
*
ERROR at line 2:
ORA-06550: line 2, column 3:
PLS-00103: Encountered the symbol "2" when expecting one of the following:
begin function package pragma procedure subtype type use
<an identifier> <a double-quoted delimited-identifier> form
current cursor
SQL> 出现上述问题,我该如何解决?请赐教。。谢谢。
oemapp worksheet
就可以进入编辑界面了