天天看点

[20120106]Extensibility Types.txt

http://docs.oracle.com/cd/B28359_01/appdev.111/b28425/ext_types_ref.htm

例子:

SQL> column text format a20

SQL> select column_value text from table (sys.ODCIVarchar2List(1,2,3,'AAA','BBB','CCC'));

TEXT

--------------------

1

2

3

AAA

BBB

CCC

6 rows selected.

SQL> select column_value num from table (sys.ODCINumberList(1,2,3,'99'));

       NUM

----------

         1

         2

         3

        99

$ echo $NLS_DATE_FORMAT

YYYY-MM-DD HH24:MI:SS

SQL>

SQL>  select column_value idate from table (sys.ODCIdateList('2012-1-1','2012-1-6 23:40:10'));

IDATE

-------------------

2012-01-01 00:00:00

2012-01-06 23:40:10