PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
* & = - + ; < / > at in is mod remainder not rem
like4 likec between || multiset member submultiset
块的内容如下:
REM labeled.sql
REM Version 1.0, last updated 5/7/97
REM This script illustrates a labeled PL/SQL block, as described in
REM Chapter 2 of _Oracle8 PL/SQL Programming_ by Scott Urman.
delete from temp_table;
set serveroutput on
<
DECLARE
v_Num1 NUMBER := 3;
v_Num2 NUMBER := 4;
v_String1 VARCHAr2(50) := 'Hello World!';
v_String2 VARCHAr2(50) := '-- This message brought to you by PL/SQL!';
v_OutputStr VARCHAr2(50);
BEGIN
INSERT INTO temp_table (num_col, char_col)
VALUES (v_Num1, v_String1);
INSERT INTO temp_table (num_col, char_col)
VALUES (v_Num2, v_String2);
SELECt char_col
INTO v_OutputStr
FROM temp_table
WHERe num_col = v_Num1;
DBMS_OUTPUT.PUT_LINE(v_OutputStr);
SELECt char_col
INTO v_OutputStr
FROM temp_table
WHERe num_col = v_Num2;
DBMS_OUTPUT.PUT_LINE(v_OutputStr);
commit;
END;
/