Redian新闻
>
infocom老是通不过edas检查
avatar
infocom老是通不过edas检查# TeX - TeX电子排版系统
s*y
1
大家说说这两个output会有区别吗(在同一个schema下)?
如果有,区别是什么?
另外, 有了user_objects,是不是CAT view其实是多余的?
(1)
select distinct table_name
from cat
(2)
select distinct object_name
from user_objects
where object_type in
(
select distinct table_type
from cat
)
)
avatar
p*s
2
【 以下文字转载自 CS 讨论区 】
发信人: Papers (34), 信区: CS
标 题: infocom老是通不过edas检查
发信站: BBS 未名空间站 (Wed Jul 21 20:57:42 2010, 美东)
用的tex写的,加了infocom网站那个page numbering 的code就说text hight超了
不用页码就能通过edas formatting checks,有没有同学是同样的问题啊?
avatar
B*g
3
oracle 9i, user_objects should cover cat
CREATE OR REPLACE FORCE VIEW sys.user_objects
(
object_name,
subobject_name,
object_id,
data_object_id,
object_type,
created,
last_ddl_time,
timestamp,
status,
temporary,
generated,
secondary
) AS
SELECT o.name,
o.subname,
o.obj#,
o.dataobj#,
DECODE (o.type#,
0, 'NEXT OBJECT',
1, 'INDEX',
2, 'TABLE',
3, 'CLUSTER',
4, 'VIEW',
5, 'SYNONYM',
6, 'SEQUENCE',
7, 'PROCEDURE',
8, 'FUNCTION',
9, 'PACKAGE',
11, 'PACKAGE BODY',
12, 'TRIGGER',
13, 'TYPE',
14, 'TYPE BODY',
19, 'TABLE PARTITION',
20, 'INDEX PARTITION',
21, 'LOB',
22, 'LIBRARY',
23, 'DIRECTORY',
24, 'QUEUE',
28, 'JAVA SOURCE',
29, 'JAVA CLASS',
30, 'JAVA RESOURCE',
32, 'INDEXTYPE',
33, 'OPERATOR',
34, 'TABLE SUBPARTITION',
35, 'INDEX SUBPARTITION',
40, 'LOB PARTITION',
41, 'LOB SUBPARTITION',
42, 'MATERIALIZED VIEW',
43, 'DIMENSION',
44, 'CONTEXT',
46, 'RULE SET',
47, 'RESOURCE PLAN',
48, 'CONSUMER GROUP',
51, 'SUBSCRIPTION',
52, 'LOCATION',
55, 'XML SCHEMA',
56, 'JAVA DATA',
57, 'SECURITY PROFILE',
59, 'RULE',
62, 'EVALUATION CONTEXT',
'UNDEFINED'
),
o.ctime,
o.mtime,
TO_CHAR (o.stime, 'YYYY-MM-DD:HH24:MI:SS'),
DECODE (o.status, 0, 'N/A', 1, 'VALID', 'INVALID'),
DECODE (BITAND (o.flags, 2), 0, 'N', 2, 'Y', 'N'),
DECODE (BITAND (o.flags, 4), 0, 'N', 4, 'Y', 'N'),
DECODE (BITAND (o.flags, 16), 0, 'N', 16, 'Y', 'N')
FROM sys.obj$ o
WHERE o.owner# = USERENV ('SCHEMAID')
AND o.linkname IS NULL
AND (o.type# NOT IN (1 /* INDEX - handled below
*/
, 10 /* NON-EXISTENT
*/
)
OR (o.type# = 1
AND 1 = (SELECT 1
FROM sys.ind$ i
WHERE i.obj# = o.obj#
AND i.type# IN (1, 2, 3, 4, 6, 7, 9))))
AND o.name != '_NEXT_OBJECT'
AND o.name != '_default_auditing_options_'
UNION ALL
SELECT l.name,
NULL,
TO_NUMBER (NULL),
TO_NUMBER (NULL),
'DATABASE LINK',
l.ctime,
TO_DATE (NULL),
NULL,
'VALID',
'N',
'N',
'N'
FROM sys.link$ l
WHERE l.owner# = USERENV ('SCHEMAID');
CREATE OR REPLACE FORCE VIEW sys.user_catalog
(
table_name,
table_type
) AS
SELECT o.name,
DECODE (o.type#,
0, 'NEXT OBJECT',
1, 'INDEX',
2, 'TABLE',
3, 'CLUSTER',
4, 'VIEW',
5, 'SYNONYM',
6, 'SEQUENCE',
'UNDEFINED'
)
FROM sys.obj$ o
WHERE o.owner# = USERENV ('SCHEMAID')
AND ( (o.type# IN (4, 5, 6))
OR (o.type# = 2 /* tables, excluding iot - overflow and nested
tables */
AND NOT EXISTS (SELECT NULL
FROM sys.tab$ t
WHERE t.obj# = o.obj#
AND (BITAND (t.property, 512) = 512
OR BITAND (t.property, 8192) = 8192))))
AND o.linkname IS NULL;

【在 s****y 的大作中提到】
: 大家说说这两个output会有区别吗(在同一个schema下)?
: 如果有,区别是什么?
: 另外, 有了user_objects,是不是CAT view其实是多余的?
: (1)
: select distinct table_name
: from cat
: (2)
: select distinct object_name
: from user_objects
: where object_type in

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。