oracle查询列名 输出文件
insertselect b.column_name||',' from user_col_comments b where b.table_name='WEB_EDR_RSN';select lower(REPLACE(b.column_name,'_','')) ||',' from user_col_comments b where b.table_name='WEB_EDR_RSN';select '#'||lower(REPLACE(b.column_name,'_','')) ||'#,' from user_col_comments b where b.table_name='WEB_EDR_RSN';updateselect b.column_name||'=''#'||lower(REPLACE(b.column_name,'_','')) ||'#,' from user_col_comments b where b.table_name='WEB_EDR_RSN'; 查询列名create or replace directory TMP as 'd:\output';declarefile_handle UTL_FILE.FILE_TYPE;output varchar2(30000);beginoutput := "....";file_handle := UTL_FILE.FOPEN('TMP', 'output.txt', 'w', 1 - 32767);--四个参数：目录，文件名，打开方式，最大行数(默认为2000)UTL_FILE.PUT_LINE(file_handle, output);UTL_FILE.FCLOSE(file_handle);exceptionWHEN utl_file.invalid_path THEN raise_application_error(-20000, 'ERROR: Invalid path for file or path not in INIT.ORA.');end;
输出文件,需要权限..貌似没啥用
页:
[1]