--PLSQL程序编写杂烦数据表信息编写批量排版
SELECT 'cra.' || lower(t.column_name) ||','
FROM dba_tab_columns t
WHERE t.table_name = 'CUX_REBATE_APPLY'
ORDER BY t.column_id;
--结果
cra.apply_id,
cra.header_id,
cra.line_number,
cra.apply_amount,
cra.apply_method_code,
cra.apply_source_id,
cra.apply_line_num,
cra.oms_flag,
cra.remark,
cra.description,
cra.source_code,
cra.source_line_id,
cra.source_reference,
cra.process_group_id,
cra.process_date,
cra.process_message,
cra.comments,
cra.row_version_number,
cra.creation_date,
cra.created_by,
cra.last_updated_by,
cra.last_update_date,
cra.last_update_login,
cra.program_application_id,
cra.program_id,
cra.program_update_date,
cra.request_id,
cra.attribute_category,
cra.attribute1,
cra.attribute2,
cra.attribute3,
cra.attribute4,
cra.attribute5,
cra.attribute6,
cra.attribute7,
cra.attribute8,
cra.attribute9,
cra.attribute10,
cra.attribute11,
cra.attribute12,
cra.attribute13,
cra.attribute14,
cra.attr
PLSQL程序编写杂烦数据表信息编写批量排版
最新推荐文章于 2022-04-14 14:25:03 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)