oracle查询列名 输出文件 博客分类： oracle oracle

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;

 

输出文件,需要权限..貌似没啥用