要加上第一句才可以:SET SERVEROUTPUT ONSET SERVEROUTPUT ON DECLARE TYPE test_rec IS RECORD( code VARCHAR2(10), name VARCHAR2(30) NOT NULL DEFAULT 'a book'); v_book test_rec; BEGIN v_book.code:='123'; v_book.name:='c++ programming'; DBMS_OUTPUT.PUT_LINE(v_book.code||v_book.name); END;
DECLARE TYPE test_rec IS RECORD( code VARCHAR2(10), name VARCHAR2(30) NOT NULL DEFAULT 'a book'); v_book test_rec; BEGIN v_book.code:='123'; v_book.name:='c++ programming'; dbms_output.enable; DBMS_OUTPUT.PUT_LINE(v_book.code||v_book.name); END;
可能还要有一句dbms_output.enable;
DECLARE
TYPE test_rec IS RECORD(
code VARCHAR2(10),
name VARCHAR2(30) NOT NULL DEFAULT 'a book');
v_book test_rec;
BEGIN
v_book.code:='123';
v_book.name:='c++ programming';
DBMS_OUTPUT.PUT_LINE(v_book.code||v_book.name);
END;
TYPE test_rec IS RECORD(
code VARCHAR2(10),
name VARCHAR2(30) NOT NULL DEFAULT 'a book');
v_book test_rec;
BEGIN
v_book.code:='123';
v_book.name:='c++ programming';
dbms_output.enable;
DBMS_OUTPUT.PUT_LINE(v_book.code||v_book.name);
END;