本文展示了如何使用SQL语句查询数据库中特定由HR拥有、包含'INTERFACE'关键字的表格。
/* Formatted on 2012/02/16 18:16 (Formatter Plus v4.8.7) */
SELECT *
FROM dba_objects i
WHERE i.object_type = 'TABLE'
AND i.object_name LIKE '%INTERFACE%'
AND i.owner LIKE 'HR'
SELECT *
FROM dba_objects i
WHERE i.object_type = 'TABLE'
AND i.object_name LIKE '%INTERFACE%'
AND i.owner LIKE 'HR'
扫一扫
6130
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
