ANAME
B
CREATE
TABLE
CREATE TABLE
(
INDEX
1
1
TABLE
2
1
) ORGANIZATION EXTERNAL
;
ANAME
B
INSERT
TABLE
INSERT
/*+
APPEND
PARALLEL("
",
)
+*/
/*+NESTED_TABLE_SET_SETID+*/
INTO RELATIONAL(
NOT XMLTYPE
)
(
INDEX
2
0
)
2
SAMPLE (
)
KU$
;
ANAME
B
SELECT
TABLE
3
SAMPLE (
)
KU$
;
ALONG_POSITION
B
ANAME
B
INSERT
TABLE
INSERT
/*+
APPEND
PARALLEL("
",
)
+*/
/*+NESTED_TABLE_SET_SETID+*/
INTO RELATIONAL(
NOT XMLTYPE
)
(
INDEX
4
0
0
0
)
VALUES (
INDEX
5
1
0
)
;
AS
1
RELATIONAL(
@
NOT XMLTYPE
)
SAMPLE (
)
AS OF SCN
KU$
***ERROR: UNEXPECTED OPERATION_TYPE:
;
ANAME
B
DROP
TABLE
DECLARE
stmt VARCHAR2(2000);
TABLE_NOT_EXIST exception;
pragma EXCEPTION_INIT(TABLE_NOT_EXIST, -942);
BEGIN
stmt := 'DROP TABLE
PURGE';
EXECUTE IMMEDIATE stmt;
EXCEPTION
WHEN TABLE_NOT_EXIST THEN NULL;
END;
/
"
".
"
"
ET$
1
SELECT
/*+ PARALLEL(KU$,
) */
INDEX
1
0
1
FROM
PARTITION ( "
" )
SUBPARTITION ( "
" )
INSERT
TABLE
DECLARE CURSOR C1 IS SELECT
INDEX
0
1
1
FROM
@
AS OF SCN
;
BEGIN
FOR C1_REC IN C1 LOOP
INSERT INTO
VALUES (
INDEX
0
0
C1_REC.
);
END LOOP;
END;
INSERT /*+ NESTED_TABLE_SET_REFS */ INTO
(
)
SELECT /*+ NESTED_TABLE_GET_REFS */
1
FROM
@
AS OF SCN
KU$
;
0
NESTED_TABLE_ID, SYS_NC_ROWINFO$
SYS_NC_ROWINFO$
SYS_NC_OID$, SYS_NC_ROWINFO$
NESTED_TABLE_ID, COLUMN_VALUE
INDEX
0
1
WHERE
tbl$or$idx$part$num(
@
,0,3,0,KU$.ROWID)=
AND