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 '%'