DBA Data[Home] [Help]

VIEW: SYS.KU$_TEMP_SUBPART_VIEW

Source

View Text - Preformatted

SELECT
            tsp.obj#,
            tsp.ts#,
            tsp.pobj#,
            dbms_metadata.get_partn(3,tsp.pobj#,tsp.subpart#)-1,
            tsp.bhiboundval
        FROM tabsubpart$ tsp
View Text - HTML Formatted

SELECT TSP.OBJ#
, TSP.TS#
, TSP.POBJ#
, DBMS_METADATA.GET_PARTN(3
, TSP.POBJ#
, TSP.SUBPART#)-1
, TSP.BHIBOUNDVAL
FROM TABSUBPART$ TSP