MS
Size: a a a
MS
IR
IR
V
GK
VG
SP
SP
АИ
AL
S
ЧП
AS
ДК
SELECT NULL AS table_cat ,
o.owner AS table_schem,
o.object_name AS table_name ,
o.object_type AS table_type ,
NULL AS remarks
FROM all_objects o
WHERE o.owner LIKE :1 ESCAPE '/'
AND o.object_name LIKE :2 ESCAPE '/'
AND o.object_type IN ('xxx', 'TABLE')
ORDER BY table_type,
table_schem,
table_name
O
SELECT NULL AS table_cat ,
o.owner AS table_schem,
o.object_name AS table_name ,
o.object_type AS table_type ,
NULL AS remarks
FROM all_objects o
WHERE o.owner LIKE :1 ESCAPE '/'
AND o.object_name LIKE :2 ESCAPE '/'
AND o.object_type IN ('xxx', 'TABLE')
ORDER BY table_type,
table_schem,
table_name