获取AP的API列表
select substr(a.owner, 1, 20),
substr(a.name, 1, 30),
substr(a.type, 1, 20),
substr(u.status, 1, 10) stat,
u.last_ddl_time,
substr(text, 1, 80) description
from dba_source a,
dba_objects u
where 2 = 2
and u.object_name = a.name
and a.text like '%Header%'
and a.type = u.object_type
and a.name like 'AP_%API%'
order by a.owner,
a.name;
substr(a.name, 1, 30),
substr(a.type, 1, 20),
substr(u.status, 1, 10) stat,
u.last_ddl_time,
substr(text, 1, 80) description
from dba_source a,
dba_objects u
where 2 = 2
and u.object_name = a.name
and a.text like '%Header%'
and a.type = u.object_type
and a.name like 'AP_%API%'
order by a.owner,
a.name;
成长
/ | \
学习 总结 分享
QQ交流群:122230156
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步