You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for DBA_RULES


1 to 12 of 12 results.


Database Reference, 12c Release 1 (12.1)

DBA_RULES

5.276 DBA_RULESDBA_RULES describes all rules in the database. Its columns are the same as those in ALL_RULES. See Also: \" ALL_RULES \"

Database Reference, 12c Release 1 (12.1)

ALL_RULES

3.33 ALL_RULESALL_RULES describes the rules accessible to the current user. Related Views DBA_RULES describes all … with the rule, if any See Also: \" DBA_RULES \" \" USER_RULES \"

Streams Concepts and Administration, 12c Release 1 (12.1)

Monitoring Rules

Listing Each Rule that Contains a Specified Pattern in Its ConditionName' FORMAT A30 SELECT RULE_OWNER, RULE_NAME FROM DBA_RULES WHERE DBMS_LOB.INSTR(RULE_CONDITION

Streams Concepts and Administration, 12c Release 1 (12.1)

Monitoring Rules

Displaying the Condition for Each Rule in a Rule SetCondition' FORMAT A45 SELECT R.RULE_OWNER, R.RULE_NAME, R.RULE_CONDITION FROM DBA_RULES R

Streams Concepts and Administration, 12c Release 1 (12.1)

Managing Rules

Altering a RuleACTION_CONTEXT_NAME, AC.NVN_VALUE.ACCESSNUMBER() AC_VALUE_NUMBER FROM DBA_RULES R, TABLE … RULE_ACTION_CONTEXT INTO action_ctx FROM DBA_RULES R WHERE RULE_OWNER='STRMADMIN' AND RULE_NAME … := SYS.RE$NV_LIST(SYS.RE$NV_ARRAY()); SELECT RULE_ACTION_CONTEXT INTO action_ctx FROM DBA_RULES R WHERE … () AC_VALUE_NUMBER, AC.NVN_VALUE.ACCESSVARCHAR2()

Streams Concepts and Administration, 12c Release 1 (12.1)

Monitoring Rules

Displaying All of the Rules in a Rule Set, R.RULE_EVALUATION_CONTEXT_NAME, R.RULE_EVALUATION_CONTEXT_OWNER FROM DBA_RULES R, DBA_RULE_SET_RULES

Streams Concepts and Administration, 12c Release 1 (12.1)

Monitoring an Oracle Streams Environment

Table 22-1 Oracle Streams Static Data Dictionary ViewsALL_RULE_SETS DBA_RULE_SETS USER_RULE_SETS ALL_RULES DBA_RULES USER_RULES N/A DBA_STREAMS_ADD_COLUMN N/A N

Streams Concepts and Administration, 12c Release 1 (12.1)

Managing Rule-Based Transformations

Altering a Custom Rule-Based TransformationDBA_RULES R, TABLE(R.RULE_ACTION_CONTEXT.ACTX_LIST) AC WHERE RULE_NAME = 'DEPARTMENTS5'; This query

Database Reference, 12c Release 1 (12.1)

Database Reference - Contents

ContentsDBA_RULE_SET_RULES 5.275 DBA_RULE_SETS 5.276 DBA_RULES 5.277 DBA_SCHEDULER_CHAIN_RULES 5.278

Streams Concepts and Administration, 12c Release 1 (12.1)

Managing Rule-Based Transformations

Creating a Custom Rule-Based TransformationACTION_CONTEXT_NAME, AC.NVN_VALUE.ACCESSVARCHAR2() ACTION_CONTEXT_VALUE FROM DBA_RULES R, TABLE … () ACTION_CONTEXT_VALUE FROM DBA_RULES R, TABLE(R.RULE_ACTION_CONTEXT.ACTX_LIST) AC WHERE RULE_NAME IN

Streams Replication Administrator's Guide, 12c Release 1 (12.1)

Instantiation and Oracle Streams Replication

Oracle Data Pump Import and Oracle Streams InstantiationALL_RULES, ALL_RULE_SETS, ALL_RULE_SET_RULES, DBA_RULES, DBA_RULE_SETS, DBA_RULE_SET_RULES, USER_RULES

Database Migration Assistant for Unicode Guide, 12c Release 1 (12.1)

Advanced Topics in the DMU

Cleansing Data Dictionary Tablesviews such as DBA_TABLES, DBA_TAB_COLUMNS, DBA_RULES, DBA_SCHEDULER_JOBS, and many others. To