开发者

How do I get the list of Audit tables in my database?

开发者 https://www.devze.com 2023-02-20 07:33 出处:网络
I need to populate a drop down list in my ASP.NET application with the list of Audit tables existing in my Oracle database. All the Audit table names start with AUD_.

I need to populate a drop down list in my ASP.NET application with the list of Audit tables existing in my Oracle database. All the Audit table names start with AUD_.

开发者_StackOverflow中文版Is there any query that can select the list of these audit tables? If not, what is the way to achieve this?


SELECT * FROM user_objects WHER object_name LIKE 'AUD%'
0

精彩评论

暂无评论...
验证码 换一张
取 消