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