35.65 SDO_UTIL.THEME3D_HAS_TEXTURE
Format
SDO_UTIL.THEME3D_HAS_TEXTURE( theme_name IN VARCHAR2 ) RETURN NUMBER;
Description
Checks if a 3D theme has textures (for DEM, TIN, map tile server, and SDO_GEOMETRY themes).
Parameters
- theme_name
-
Name of the 3D theme. Must be a value from the USER_SDO_3DTHEMES or ALL_SDO_3DTHEMES view (described in xxx_SDO_3DTHEMES Views.
Usage Notes
Note:
SDO_UTIL.THEME3D_HAS_TEXTURE function is not supported in Oracle Autonomous Database Serverless deployments.This function returns 0 (zero) if the theme does not have textures; otherwise, it returns 1.
Examples
This example does the following for each theme in the USER_SDO_3DTHEMES table: checks if it has multiple LODs and has texture, and returns the block table name. (It assumes that the themes were previously inserted into the USER_SDO_3DTHEMES table.)
SELECT name, sdo_util.theme3d_has_lod(name) "Has LOD", sdo_util.theme3d_has_texture(name) "Has Texture", sdo_util.theme3d_get_block_table(name) "Block Table" FROM user_sdo_3dthemes ORDER BY name; NAME Has LOD Has Texture Block Table -------------------------------- ---------- ----------- ------------------------- DEM Hawaii Theme 4326 1 0 DEM_BLOCKS_HAWAII_4326 DEM Hawaii Theme w/ Map Tiles 1 1 DEM_BLOCKS_HAWAII_4326 DEM Splitted Theme 1 0 DEM_SPLITTED_HAWAII_4326 Geom Theme 0 0 GeomForDEM Theme 0 0 GeomForTIN Theme 0 0 PC Category Theme 1 0 PC_BLOCKS_CATEGORY PC Hawaii Theme 4326 1 0 PC_BLOCKS_HAWAII_4326 PC Intensity Theme 1 0 PC_BLOCKS_INTENSITY PC LAS File Theme 1 0 PC_BLOCKS_LAS PC RGB Theme 1 0 PC_BLOCKS_RGB PC Split Theme 1 0 PC_SPLIT_BLOCKS_4326 PC Subset Hawaii Theme 1 0 PC_SUBSET_BLOCKS_4326 PC Theme 0 0 PC_BLOCKS_NULL_CRS TIN Hawaii Theme 4326 1 0 TIN_BLOCKS_HAWAII_4326 TIN Hawaii Theme w/ Map Tiles 1 1 TIN_BLOCKS_HAWAII_4326 TIN Split Theme 1 0 TIN_SPLIT_BLOCKS_4326 TIN Subset Hawaii Theme 1 0 TIN_SUBSET_BLOCKS_4326 18 rows selected.
Related Topics
Parent topic: SDO_UTIL Package (Utility)