| Secured content area views

Related topics
Secured views are provided for all content area objects (sbrapi.vw). Some objects are not secured because within Oracle Portal they have no security associated with them (such as item types). The database views can be used in conjunction with the content area API packages wwsbr_api and wwsbr_search_api. Note: Access to these views is not granted automatically during installation. Use sbrapi.sql to grant access to all the views and wwsbr_api packages to a specific user.
Version: Oracle Portal 3.0.8 (Not available Oracle9iAS Portal 9.0.2)
Content area views
WWSBR_ALL_FOLDERS
WWSBR_USER_FOLDERS
WWSBR_FOLDER_PERSPECTIVES
WWSBR_FOLDER_ATTRIBUTES
WWSBR_ALL_ITEMS
WWSBR_ITEM_PERSPECTIVES
WWSBR_ITEM_ATTRIBUTES
WWSBR_ALL_CATEGORIES
WWSBR_ALL_PERSPECTIVES
WWSBR_ALL_CONTENT_AREAS
WWSBR_ATTRIBUTES
WWSBR_ITEM_TYPES
WWSBR_CONTENT_AREA_ITEM_TYPES
WWSBR_ITEM_TYPE_ATTRIBUTES
WWSBR_FOLDER_TYPES
WWSBR_FOLDER_TYPE_ATTRIBUTES
WWSBR_ALL_NAVIGATION_BARS
WWSBR_ALL_STYLES
WWSBR_ALL_FOLDER_REGIONS

WWSBR_ALL_FOLDERS view

Name | Null? | Type
ID | NOT NULL | NUMBER
CAID | NOT NULL | NUMBER
LANGUAGE | NOT NULL | VARCHAR2(30)
NAME | NOT NULL | VARCHAR2(60)
DISPLAY_NAME | NOT NULL | VCHAR2(256)
CATEGORY_ID |  | NUMBER
CATEGORY_SITEID |  | NUMBER
DESCRIPTION |  | VARCHAR2(2000)
TYPE_ID | NOT NULL | NUMBER
TYPE_SITEID | NOT NULL | NUMBER
BASE_TYPE_ID | NOT NULL | NUMBER
IS_PORTLET | NOT NULL | NUMBER(1)
IS_CACHING_ON | NOT NULL | NUMBER
SUB_FOLDER_SEQUENCE |  | NUMBER
DISPLAY_IN_PARENT_FOLDER | NOT NULL | NUMBER(1)
ITEMVERSIONING |  | VARCHAR2(30)
STYLE_ID | NOT NULL | NUMBER
STYLE_CAID | NOT NULL | NUMBER
URL_VALUE |  | VARCHAR2(4000)
SEARCH_VALUE |  | VARCHAR2(2000)
PLSQL_VALUE |  | VARCHAR2(2000)
TITLE_IMAGE_NAME |  | VARCHAR2(350)
ROLLOVER_IMAGE_NAME |  | VARCHAR2(350)
BANNER_IMAGE_NAME |  | VARCHAR2(350)
NAVIGATION_BAR_ID |  | NUMBER
NAVIGATION_BAR_CAID | NOT NULL | NUMBER
IS_PUBLIC | NOT NULL | NUMBER(1)
ITEM_LEVEL_SECURITY | NOT NULL | NUMBER(1)
DISPLAY_FULL_SCREEN | NOT NULL | NUMBER(1)
PLSQL_FOLDER_EXECUTOR |  | VARCHAR2(30)
CREATEDATE |  | DATE
CREATOR |  | VARCHAR2(30)
UPDATEDATE |  | DATE
UPDATOR |  | VARCHAR2(30)

WWSBR_USER_FOLDERS view

Name | Null? | Type
ID | NOT NULL | NUMBER
CAID | NOT NULL | NUMBER
LANGUAGE | NOT NULL | VARCHAR2(30)
NAME | NOT NULL | VARCHAR2(60)
DISPLAY_NAME | NOT NULL | VARCHAR2(256)
CATEGORY_ID |  | NUMBER
CATEGORY_CAID |  | NUMBER
DESCRIPTION |  | VARCHAR2(2000)
TYPE_ID | NOT NULL | NUMBER
TYPE_CAID | NOT NULL | NUMBER
BASE_TYPE_ID | NOT NULL | NUMBER
IS_PORTLET | NOT NULL | NUMBER(1)
IS_CACHING_ON | NOT NULL | NUMBER
SUB_FOLDER_SEQUENCE |  | NUMBER
DISPLAY_IN_PARENT_FOLDER | NOT NULL | NUMBER(1)
ITEMVERSIONING |  | VARCHAR2(30)
STYLE_ID | NOT NULL | NUMBER
STYLE_CAID | NOT NULL | NUMBER
URL_VALUE |  | VARCHAR2(4000)
SEARCH_VALUE |  | VARCHAR2(2000)
PLSQL_VALUE |  | VARCHAR2(2000)
TITLE_IMAGE_NAME |  | VARCHAR2(350)
ROLLOVER_IMAGE_NAME |  | VARCHAR2(350)
BANNER_IMAGE_NAME |  | VARCHAR2(350)
NAVIGATION_BAR_ID |  | NUMBER
NAVIGATION_BAR_CAID | NOT NULL | NUMBER
IS_PUBLIC | NOT NULL | NUMBER(1)
ITEM_LEVEL_SECURITY | NOT NULL | NUMBER(1)
DISPLAY_FULL_SCREEN | NOT NULL | NUMBER(1)
PLSQL_FOLDER_EXECUTOR |  | VARCHAR2(30)
CREATEDATE |  | DATE
CREATOR |  | VARCHAR2(30)
UPDATEDATE |  | DATE
UPDATOR |  | VARCHAR2(30)

WWSBR_FOLDER_PERSPECTIVES view

Name | Null? | Type
FOLDER_CAID | NOT NULL | NUMBER
FOLDER_ID | NOT NULL | NUMBER
PERSPECTIVE_ID | NOT NULL | NUMBER
PERSPECTIVE_CAID | NOT NULL | NUMBER
PERSPCTIVE_NAME |  | VARCHAR2(60

WWSBR_FOLDER_ATTRIBUTES view

Name | Null? | Type
FOLDER_CAID | NOT NULL | NUMBER
FOLDER_ID | NOT NULL | NUMBER
ATTRIBUTE_ID |  | NUMBER
ATTRIBUTE_CAID |  | NUMBER
LANGUAGE | NOT NULL | VARCHAR2(30)
VALUETYPE | NOT NULL | VARCHAR2(30)
VALUE |  | VARCHAR2(2000)

WWSBR_ALL_ITEM view

Active values for items are awaiting approval and deleted (-2), deleted (-1), awaiting approval (0) and active (1).

Name | Null? | Type
MASTERID | NOT NULL | NUMBER
ID | NOT NULL | NUMBER
CAID | NOT NULL | NUMBER
LANGUAGE | NOT NULL | VARCHAR2(30)
FOLDER_ID | NOT NULL | NUMBER
FOLDER_REGION_ID | NOT NULL | NUMBER
NAME | NOT NULL | VARCHAR2(256)
DISPLAY_NAME |  | VARCHAR2(256)
ITEMTYPE | NOT NULL | VARCHAR2(30)
TYPE | NOT NULL | VARCHAR2(30)
SUBTYPE |  | VARCHAR2(40)
PARENT_ITEM_ID |  | NUMBER
CATEGORY_ID |  | NUMBER
CATEGORY_CAID |  | NUMBER
AUTHOR |  | VARCHAR2(50)
DESCRIPTION |  | VARCHAR2(2000)
PUBLISH_DATE |  | DATE
EXPIREDATE |  | DATE
IMAGE |  | VARCHAR2(350)
KEYWORDS |  | VARCHAR2(2000)
URL |  | VARCHAR2(4000)
FILENAME |  | VARCHAR2(350)
TEXT |  | CLOB
FOLDER_LINK_ID |  | NUMBER
FOLDER_LINK_CAID |  | NUMBER
ACTIVE |  | NUMBER(1)
CAN_BE_CHECKEDOUT | NOT NULL | NUMBER(1)
IS_ITEM_CHECKEDOUT |  | NUMBER(1)
CHECKER_USERNAME |  | VARCHAR2(30)
CHECKOUT_DATE |  | DATE
FULLSCREEN | NOT NULL | NUMBER(1)
INPLACE | NOT NULL | NUMBER(1)
HIDEINBROWSE |  | NUMBER(1)
CREATEDATE | NOT NULL | DATE
CREATOR | NOT NULL | VARCHAR2(30)
UPDATEDATE |  | DATE
UPDATOR |  | VARCHAR2(30)
SEQ | NOT NULL | NUMBER
AUTHOR_SEQ | NOT NULL | NUMBER
CREATEDATE_SEQ | NOT NULL | NUMBER
ITEMTYPE_SEQ | NOT NULL | NUMBER

WWSBR_ITEM_PERSPECTIVES view

Name | Null? | Type
ITEM_CAID | NOT NULL | NUMBER
ITEM_MASTERID |  | NUMBER
PERSPECTIVE_ID | NOT NULL | NUMBER
PERSPECTIVE_CAID | NOT NULL | NUMBER
PERSPCTIVE_NAME |  | VARCHAR2(60)

WWSBR_ITEM_ATTRIBUTES view

Name | Null? | Type
ITEM_CAID | NOT NULL | NUMBER
ITEM_MASTERID | NOT NULL | NUMBER
ATTRIBUTE_ID |  | NUMBER
ATTRIBUTE_CAID |  | NUMBER
LANGUAGE | NOT NULL | VARCHAR2(30)
VALUETYPE | NOT NULL | VARCHAR2(30)
VALUE |  | VARCHAR2(2000)

WWSBR_ALL_CATEGORIES view

Name | Null? | Type
ID | NOT NULL | NUMBER
CAID | NOT NULL | NUMBER
LANGUAGE | NOT NULL | VARCHAR2(30)
NAME |  | VARCHAR2(60)
DISPLAY_NAME | NOT NULL | VARCHAR2(240)

WWSBR_ALL_PERSPECTIVES view

Name | Null? | Type
ID | NOT NULL | NUMBER
CAID | NOT NULL | NUMBER
LANGUAGE | NOT NULL | VARCHAR2(30)
NAME |  | VARCHAR2(60)
DISPLAY_NAME | NOT NULL | VARCHAR2(240)

WWSBR_ALL_CONTENT_AREAS view

Name | Null? | Type
ID | NOT NULL | NUMBER
NAME | NOT NULL | VARCHAR2(60)
DEFAULT_LANGUAGE | NOT NULL | VARCHAR2(30)

WWSBR_ATTRIBUTES view

Name | Null? | Type
ID | NOT NULL | NUMBER
CAID | NOT NULL | NUMBER
LANGUAGE | NOT NULL | VARCHAR2(30)
NAME | NOT NULL | VARCHAR2(256)
DISPLAY_NAME |  | VARCHAR2(256)
IS_BASE_ATTRIBUTE | NOT NULL | NUMBER(1)
DATA_TYPE | NOT NULL | VARCHAR2(30
LENGTH |  | NUMBER(5)
IS_TRANSLATABLE | NOT NULL | NUMBER(1)

WWSBR_ITEM_TYPES views

Name | Null? | Type
ID | NOT NULL | NUMBER
CAID | NOT NULL | NUMBER
LANGUAGE | NOT NULL | VARCHAR2(30)
NAME |  | VARCHAR2(30)
DISPLAY_NAME |  | VARCHAR2(256)
DESCRIPTION |  | VARCHAR2(2000)
IS_BASE_ITEM_TYPE | NOT NULL | NUMBER
BASE_ITEM_TYPE_ID |  | NUMBER
BASE_ITEM_TYPE | NOT NULL | VARCHAR2(30)

WWSBR_CONTENT_AREA_ITEM_TYPES view

This view shows which item types are available to which content areas.

Name | Null? | Type
CAID | NOT NULL | NUMBER
ITEM_TYPE_ID | NOT NULL | NUMBER
ITEM_TYPE_CAID | NOT NULL | NUMBER

WWSBR_ITEM_TYPE_ATTRIBUTES view

Name | Null? | Type
ID | NOT NULL | NUMBER
CAID | NOT NULL | NUMBER
LANGUAGE | NOT NULL | VARCHAR2(30)
ITEM_TYPE_ID | NOT NULL | NUMBER
ITEM_TYPE_CAID | NOT NULL | NUMBER
ATTRIBUTE_ID | NOT NULL | NUMBER
ATTRIBUTE_CAID | NOT NULL | NUMBER
HIDDEN_ATTRIBUTE | NOT NULL | NUMBER(1)
DEFAULT_VALUE |  | VARCHAR2(2000)

WWSBR_FOLDER_TYPES view

Name | Null? | Type
ID | NOT NULL | NUMBER
CAID | NOT NULL | NUMBER
LANGUAGE | NOT NULL | VARCHAR2(30)
NAME |  | VARCHAR2(30)
DISPLAY_NAME |  | VARCHAR2(256)
DESCRIPTION |  | VARCHAR2(2000)
IS_BASE_FOLDER_TYPE | NOT NULL | NUMBER
BASE_FOLDER_TYPE_ID |  | NUMBER

WWSBR_FOLDER_TYPE_ATTRIBUTES view

Name | Null? | Type
ID | NOT NULL | NUMBER
CAID | NOT NULL | NUMBER
LANGUAGE | NOT NULL | VARCHAR2(30)
FOLDER_TYPE_ID | NOT NULL | NUMBER
FOLDER_TYPE_CAID | NOT NULL | NUMBER
ATTRIBUTE_ID | NOT NULL | NUMBER
ATTRIBUTE_CAID | NOT NULL | NUMBER
DEFAULT_VALUE |  | VARCHAR2(2000)

WWSBR_ALL_NAVIGATION_BARS view

Name | Null? | Type
ID | NOT NULL | NUMBER
CAID | NOT NULL | NUMBER
LANGUAGE | NOT NULL |
NAME | NOT NULL |
DISPLAY_NAME | NOT NULL |
STYLE_ID | NOT NULL | NUMBER
STYLE_CAID |  | NUMBER
IS_PORTLET | NOT NULL | NUMBER(1)
ALIGNMENT | NOT NULL | VARCHAR2(10)

WWSBR_ALL_STYLES view

Name | Null? | Type
ID | NOT NULL | NUMBER
CAID | NOT NULL | NUMBER
LANGUAGE | NOT NULL | VARCHAR2(30)
NAME | NOT NULL | VARCHAR2(65)
DISPLAY_NAME |  | VARCHAR2(350)

WWSBR_ALL_FOLDER_REGIONS view

Name | Null? | Type
ID | NOT NULL | NUMBER
DISPLAY_NAME | NOT NULL | VARCHAR2(60)
LANGUAGE | NOT NULL | VARCHAR2(30)
FOLDER_ID | NOT NULL | NUMBER
FOLDER_CAID | NOT NULL | NUMBER

Related topics
Content area API package | PDK PL/SQL API Reference - Home

Back to top
The PL/SQL API Reference is part of the Portal Developer Kit on Portal Studio