DECLARE
vNum NUMBER(2);
BEGIN
vNum := 1 ;
DBMS_OUTPUT.PUT_LINE('数値=' || vNum);
END;
/
変数を伴う実行
SELECT TABLE_NAME
, COLUMN_NAME
, DATA_TYPE
, NULLABLE
FROM USER_TAB_COLUMNS
WHERE COLUMN_NAME LIKE '%'
DECLARE
vNum NUMBER(2);
BEGIN
vNum := 1 ;
DBMS_OUTPUT.PUT_LINE('数値=' || vNum);
END;
/
変数を伴う実行
SELECT TABLE_NAME
, COLUMN_NAME
, DATA_TYPE
, NULLABLE
FROM USER_TAB_COLUMNS
WHERE COLUMN_NAME LIKE '%'