insert
select 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';
update
select 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';
declare
file_handle UTL_FILE.FILE_TYPE;
output varchar2(30000);
begin
output := "....";
file_handle := UTL_FILE.FOPEN('TMP', 'output.txt', 'w', 1 - 32767);
--四个参数:目录,文件名,打开方式,最大行数(默认为2000)
UTL_FILE.PUT_LINE(file_handle, output);
UTL_FILE.FCLOSE(file_handle);
exception
WHEN utl_file.invalid_path THEN
raise_application_error(-20000,
'ERROR: Invalid path for file or path not in INIT.ORA.');
end;
输出文件,需要权限..貌似没啥用