 what is object_type operator??? [message #155843] |
Wed, 18 January 2006 21:31  |
raddisonlee
Messages: 29
Registered: March 2005
|
Junior Member |
|
|
SQL> select object_type ,count(*) from dba_objects group by object_type;
OBJECT_TYPE COUNT(*)
------------------ ----------
CLUSTER 10
CONSUMER GROUP 4
CONTEXT 2
DATABASE LINK 3
DIMENSION 5
DIRECTORY 3
EVALUATION CONTEXT 11
FUNCTION 99
INDEX 996
INDEX PARTITION 128
INDEXTYPE 9
OBJECT_TYPE COUNT(*)
------------------ ----------
JAVA CLASS 9955
JAVA DATA 291
JAVA RESOURCE 190
JAVA SOURCE 16
LIBRARY 90
LOB 366
MATERIALIZED VIEW 2
OPERATOR 28 -----------<<<<<
PACKAGE 554
PACKAGE BODY 499
PROCEDURE 39
OBJECT_TYPE COUNT(*)
------------------ ----------
QUEUE 40
RESOURCE PLAN 3
RULE SET 15
SEQUENCE 121
SYNONYM 11562
TABLE 881
TABLE PARTITION 55
TRIGGER 89
TYPE 851
TYPE BODY 56
VIEW 2543
OBJECT_TYPE COUNT(*)
------------------ ----------
XML SCHEMA 10
34 rows selected.
how to understand the type "operator" and where to use with ????
|
|
|
|
| Re: what is object_type operator??? [message #155904 is a reply to message #155843] |
Thu, 19 January 2006 10:20  |
Gerardo Fernandez Herrera
Messages: 58
Registered: January 2006
Location: Montevideo, Uruguay
|
Member |
|
|
User-defined operators are part of the Oracle object-relational features.
In a few words, it allows you to add more operators to the traditional ones, as IN, OR, AND, +, -, etc. and use them in your queries.
Look for Operators in the SQL Reference and in the Application Developer's Guide - Object-Relational Features manuals.
Regards.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
