随笔分类 - Oracle
摘要：select table_name from user_tables;
阅读全文
摘要：1、创建 create or replace procedure A_YANDANCHAN is -- 名称A_YANDANCHAN可以改掉 v_sql VARCHAR2(4000); v_tb_column VARCHAR2(4000); v_cnt NUMBER(18,0); v_key VAR
阅读全文
摘要：select listagg(COLUMN_NAME,',')within group(order by COLUMN_NAME)name from all_tab_columns where table_name = '表名';
阅读全文
