(row_txt_clob, TRUE); -- Generate SQL from row LCR and save to file lcr.GET_ROW_TEXT(row_txt_clob); fp := UTL_FILE.FOPEN ( location => 'SQL_GEN_DIR', filename => 'sql_gen_file.txt', open_mode => 'a', max_linesize => 5000); UTL_FILE.PUT_LINE( file => fp, buffer...
2DBMS_LOB 3DBMS_LOCK DBMS_LOCKの使用 DBMS_LOCKサブプログラムの要約 SLEEPプロシージャ 4DBMS_OUTPUT 5DBMS_PREPROCESSOR 6DBMS_RANDOM 7DBMS_SQL 8DBMS_UTILITY 9TT_DB_VERSION 10TT_STATS 11UTL_FILE 12UTL_IDENT 13UTL_RAW 14UTL_RECOMP ...
UTL_FILEを使用した、アタッチされたファイル・システム上のファイルの書込みを示す例: コピー DECLARE l_file UTL_FILE.FILE_TYPE; l_location VARCHAR2(100) := 'FSS_DIR'; l_filename VARCHAR2(100) := 'test.csv'; BEGIN -- Open the file. l_file := UTL_FILE.FOPEN(l_location,...
(row_txt_clob, TRUE); -- Generate SQL from row LCR and save to file lcr.GET_ROW_TEXT(row_txt_clob); fp := UTL_FILE.FOPEN ( location => 'SQL_GEN_DIR', filename => 'sql_gen_file.txt', open_mode => 'a', max_linesize => 5000); UTL_FILE.PUT_LINE( file => fp, buffer...