Table of Contents 1 Introduction 1.1 What’s New 1.2 Typographical Conventions Used in this Guide 1.3 Other Conventions Used in this Guide 1.4 About the Examples Used in this Guide 1.4.1.1 Sample Database Description 2 Database Administration 2.1 Configuration Parameters 2.1.1 Setting Configuration Parameters 2.1.2 Summary of Configuration Parameters 2.1.3 Configuration Parameters by Functionality 2.1.3.1 Top Performance Related Parameters 2.1.3.1.1 shared_buffers 2.1.3.1.2 work_mem 2.1.3.1.3 maintenance_work_mem 2.1.3.1.4 wal_buffers 2.1.3.1.5 checkpoint_segments 2.1.3.1.6 checkpoint_completion_target 2.1.3.1.7 checkpoint_timeout 2.1.3.1.8 bgwriter_delay 2.1.3.1.9 seq_page_cost 2.1.3.1.10 random_page_cost 2.1.3.1.11 effective_cache_size 2.1.3.1.12 synchronous_commit 2.1.3.1.13 edb_max_spins_per_delay 2.1.3.2 Resource Usage / Memory 2.1.3.2.1 edb_dynatune 2.1.3.2.2 edb_dynatune_profile 2.1.3.2.3 edb_enable_icache 2.1.3.2.4 edb_icache_servers 2.1.3.2.5 edb_icache_compression_level 2.1.3.3 Resource Usage / EDB Resource Manager 2.1.3.3.1 edb_max_resource_groups 2.1.3.3.2 edb_resource_group 2.1.3.4 Query Tuning 2.1.3.4.1 enable_hints 2.1.3.5 Query Tuning / Planner Method Configuration 2.1.3.5.1 edb_custom_plan_tries 2.1.3.5.2 edb_enable_pruning 2.1.3.6 Reporting and Logging / What to Log 2.1.3.6.1 trace_hints 2.1.3.7 EnterpriseDB Auditing Settings 2.1.3.7.1 edb_audit 2.1.3.7.2 edb_audit_directory 2.1.3.7.3 edb_audit_filename 2.1.3.7.4 edb_audit_rotation_day 2.1.3.7.5 edb_audit_rotation_size 2.1.3.7.6 edb_audit_rotation_seconds 2.1.3.7.7 edb_audit_connect 2.1.3.7.8 edb_audit_disconnect 2.1.3.7.9 edb_audit_statement 2.1.3.8 Client Connection Defaults / Locale and Formatting 2.1.3.8.1 icu_short_form 2.1.3.9 Client Connection Defaults / Statement Behavior 2.1.3.9.1 default_heap_fillfactor 2.1.3.10 Client Connection Defaults / Other Defaults 2.1.3.10.1 oracle_home 2.1.3.10.2 odbc_lib_path 2.1.3.11 Compatibility Options 2.1.3.11.1 edb_redwood_date 2.1.3.11.2 edb_redwood_greatest_least 2.1.3.11.3 edb_redwood_raw_names 2.1.3.11.4 edb_redwood_strings 2.1.3.11.5 edb_stmt_level_tx 2.1.3.11.6 db_dialect 2.1.3.11.7 default_with_rowids 2.1.3.11.8 optimizer_mode 2.1.3.12 Customized Options 2.1.3.12.1 custom_variable_classes 2.1.3.12.2 dbms_alert.max_alerts 2.1.3.12.3 dbms_pipe.total_message_buffer 2.1.3.12.4 index_advisor.enabled 2.1.3.12.5 edb_sql_protect.enabled 2.1.3.12.6 edb_sql_protect.level 2.1.3.12.7 edb_sql_protect.max_protected_relations 2.1.3.12.8 edb_sql_protect.max_protected_roles 2.1.3.12.9 edb_sql_protect.max_queries_to_save 2.1.3.12.10 edbldr.empty_csv_field 2.1.3.12.11 utl_encode.uudecode_redwood 2.1.3.12.12 utl_file.umask 2.1.3.13 Ungrouped 2.1.3.13.1 nls_length_semantics 2.1.3.13.2 query_rewrite_enabled 2.1.3.13.3 query_rewrite_integrity 2.1.3.13.4 timed_statistics 2.2 Controlling the Audit Logs 2.2.1 Auditing Configuration Parameters 2.3 Unicode Collation Algorithm 2.3.1 Basic Unicode Collation Algorithm Concepts 2.3.2 International Components for Unicode 2.3.2.1 Locale Collations 2.3.2.2 Collation Attributes 2.3.3 Creating an ICU Collation 2.3.3.1 CREATE COLLATION 2.3.3.2 CREATE DATABASE 2.3.3.3 initdb 2.3.4 Using a Collation 3 Enhanced SQL Features 3.1 Synonyms 3.2 Hierarchical Queries 3.2.1 Defining the Parent/Child Relationship 3.2.2 Selecting the Root Nodes 3.2.3 Organization Tree in the Sample Application 3.2.4 Node Level 3.2.5 Ordering the Siblings 3.2.6 Retrieving the Root Node with CONNECT_BY_ROOT 3.3 Extended Functions and Operators 3.3.1 Logical Operators 3.3.2 Comparison Operators 3.3.3 Mathematical Functions and Operators 3.3.4 String Functions and Operators 3.3.5 Pattern Matching String Functions 3.3.5.1 REGEXP_COUNT 3.3.5.2 REGEXP_INSTR 3.3.5.3 REGEXP_SUBSTR 3.3.6 Pattern Matching Using the LIKE Operator 3.3.7 Data Type Formatting Functions 3.3.7.1 IMMUTABLE TO_CHAR(TIMESTAMP, format) Function 3.3.8 Date/Time Functions and Operators 3.3.8.1 ADD_MONTHS 3.3.8.2 EXTRACT 3.3.8.3 MONTHS_BETWEEN 3.3.8.4 NEXT_DAY 3.3.8.5 NEW_TIME 3.3.8.6 ROUND 3.3.8.7 TRUNC 3.3.8.8 CURRENT DATE/TIME 3.3.9 Sequence Manipulation Functions 3.3.10 Conditional Expressions 3.3.10.1 CASE 3.3.10.2 COALESCE 3.3.10.3 NULLIF 3.3.10.4 NVL 3.3.10.5 NVL2 3.3.10.6 GREATEST and LEAST 3.3.11 Aggregate Functions 3.3.12 Subquery Expressions 3.3.12.1 EXISTS 3.3.12.2 IN 3.3.12.3 NOT IN 3.3.12.4 ANY/SOME 3.3.12.5 ALL 3.3.13 Uniform Resource Locator Functions 3.3.13.1 EDB_GET_URL_AS_BYTEA 3.3.13.2 EDB_GET_URL_AS_TEXT 3.4 Table Partitioning 3.4.1 Selecting a Partition Type 3.4.2 Using Partition Pruning 3.4.3 Example - Partition Pruning 3.5 Partitioning Command Syntax 3.5.1 CREATE TABLE…PARTITION BY 3.5.1.1 Example - PARTITION BY LIST 3.5.1.2 Example - PARTITION BY RANGE 3.5.1.3 Example - PARTITION BY HASH 3.5.1.4 Example - PARTITION BY RANGE, SUBPARTITION BY LIST 3.5.2 ALTER TABLE...ADD PARTITION 3.5.2.1 Example - Adding a Partition to a LIST Partitioned Table 3.5.2.2 Example - Adding a Partition to a RANGE Partitioned Table 3.5.3 ALTER TABLE… ADD SUBPARTITION 3.5.3.1 Example - Adding a Subpartition to a LIST-RANGE Partitioned Table 3.5.3.2 Example - Adding a Subpartition to a RANGE-LIST Partitioned Table 3.5.4 ALTER TABLE...SPLIT PARTITION 3.5.4.1 Example - Splitting a LIST Partition 3.5.4.2 Example - Splitting a RANGE Partition 3.5.5 ALTER TABLE...SPLIT SUBPARTITION 3.5.5.1 Example - Splitting a LIST Subpartition 3.5.5.2 Example - Splitting a RANGE Subpartition 3.5.6 ALTER TABLE… EXCHANGE PARTITION 3.5.6.1 Example - Exchanging a Table for a Partition 3.5.7 ALTER TABLE… MOVE PARTITION 3.5.7.1 Example - Moving a Partition to a Different Tablespace 3.5.8 ALTER TABLE… RENAME PARTITION 3.5.8.1 Example - Renaming a Partition 3.5.9 DROP TABLE 3.5.10 ALTER TABLE… DROP PARTITION 3.5.10.1 Example - Deleting a Partition 3.5.11 ALTER TABLE… DROP SUBPARTITION 3.5.11.1 Example - Deleting a Subpartition 3.5.12 TRUNCATE TABLE 3.5.12.1 Example - Emptying a Table 3.5.13 ALTER TABLE… TRUNCATE PARTITION 3.5.13.1 Example - Emptying a Partition 3.5.14 ALTER TABLE… TRUNCATE SUBPARTITION 3.5.14.1 Example - Emptying a Subpartition 3.6 Handling Stray Values in a LIST or RANGE Partitioned Table 3.7 Specifying Multiple Partitioning Keys in a RANGE Partitioned Table 3.8 Retrieving Information about a Partitioned Table 3.8.1 Table Partitioning Views - Reference 3.8.1.1 ALL_PART_TABLES 3.8.1.2 ALL_TAB_PARTITIONS 3.8.1.3 ALL_TAB_SUBPARTITIONS 3.8.1.4 ALL_PART_KEY_COLUMNS 3.8.1.5 ALL_SUBPART_KEY_COLUMNS 4 Security 4.1 Protecting Against SQL Injection Attacks 4.1.1 SQL/Protect Overview 4.1.1.1 Types of SQL Injection Attacks 4.1.1.2 Monitoring SQL Injection Attacks 4.1.1.2.1 Protected Roles 4.1.1.2.2 Attack Attempt Statistics 4.1.1.2.3 Attack Attempt Queries 4.1.2 Configuring SQL/Protect 4.1.2.1 Selecting Roles to Protect 4.1.2.1.1 Setting the Protected Roles List 4.1.2.1.2 Setting the Protection Level 4.1.2.2 Monitoring Protected Roles 4.1.2.2.1 Learn Mode 4.1.2.2.2 Passive Mode 4.1.2.2.3 Active Mode 4.1.3 Common Maintenance Operations 4.1.3.1 Adding a Role to the Protected Roles List 4.1.3.2 Removing a Role From the Protected Roles List 4.1.3.3 Setting the Types of Protection for a Role 4.1.3.4 Removing a Relation From the Protected Relations List 4.1.3.5 Deleting Statistics 4.1.3.6 Deleting Offending Queries 4.1.3.7 Disabling and Enabling Monitoring 4.1.4 Backing Up and Restoring a SQL/Protect Database 4.1.4.1 Object Identification Numbers in SQL/Protect Tables 4.1.4.2 Backing Up the Database 4.1.4.3 Restoring From the Backup Files 4.2 EDB*Wrap 4.2.1 Using EDB*Wrap to Obfuscate Source Code 4.3 Virtual Private Database 5 EDB Resource Manager 5.1 Creating and Managing Resource Groups 5.1.1 CREATE RESOURCE GROUP 5.1.2 ALTER RESOURCE GROUP 5.1.3 DROP RESOURCE GROUP 5.1.4 Assigning a Process to a Resource Group 5.1.5 Removing a Process from a Resource Group 5.1.6 Monitoring Processes in Resource Groups 5.2 CPU Usage Throttling 5.2.1 Setting the CPU Rate Limit for a Resource Group 5.2.2 Example – Single Process in a Single Group 5.2.3 Example – Multiple Processes in a Single Group 5.2.4 Example – Multiple Processes in Multiple Groups 5.3 Dirty Buffer Throttling 5.3.1 Setting the Dirty Rate Limit for a Resource Group 5.3.2 Example – Single Process in a Single Group 5.3.3 Example – Multiple Processes in a Single Group 5.3.4 Example – Multiple Processes in Multiple Groups 5.4 System Catalogs 5.4.1 edb_all_resource_groups 5.4.2 edb_resource_group 6 Database Utilities 6.1 EDB*Loader 6.1.1 Data Loading Methods 6.1.2 General Usage 6.1.3 Building the EDB*Loader Control File 6.1.4 Invoking EDB*Loader 6.1.4.1 Exit Codes 6.1.5 Direct Path Load 6.1.6 Parallel Direct Path Load 6.1.7 Remote Loading 6.1.8 Updating a Table with a Conventional Path Load 6.1.9 Loading Empty Strings with EDB*Loader 6.2 EDB*Plus 6.2.1 Starting EDB*Plus 6.2.2 Command Summary 6.2.2.1 ACCEPT 6.2.2.2 APPEND 6.2.2.3 CHANGE 6.2.2.4 CLEAR 6.2.2.5 COLUMN 6.2.2.6 CONNECT 6.2.2.7 DEFINE 6.2.2.8 DEL 6.2.2.9 DESCRIBE 6.2.2.10 DISCONNECT 6.2.2.11 EDIT 6.2.2.12 EXECUTE 6.2.2.13 EXIT 6.2.2.14 GET 6.2.2.15 HELP 6.2.2.16 HOST 6.2.2.17 INPUT 6.2.2.18 LIST 6.2.2.19 PASSWORD 6.2.2.20 PAUSE 6.2.2.21 PRINT 6.2.2.22 PROMPT 6.2.2.23 QUIT 6.2.2.24 REMARK 6.2.2.25 SAVE 6.2.2.26 SET 6.2.2.27 SHOW 6.2.2.28 SPOOL 6.2.2.29 START 6.2.2.30 UNDEFINE 6.2.2.31 WHENEVER SQLERROR 6.3 libpq C Library 6.3.1 Using libpq with EnterpriseDB SPL 6.3.2 REFCURSOR Support 6.3.3 Array Binding 6.3.3.1 PQBulkStart 6.3.3.2 PQexecBulk 6.3.3.3 PQBulkFinish 6.3.3.4 PQexecBulkPrepared 6.3.3.5 Example Code (Using PQBulkStart, PQexecBulk, PQBulkFinish) 6.3.3.6 Example Code (Using PQexecBulkPrepared) 6.4 ECPGPlus 6.4.1 C-preprocessor Directives 6.4.2 Supported C Data Types 6.4.3 Type Codes 6.4.4 The SQLDA Structure 6.4.5 ECPGPlus Statements 6.4.5.1 ALLOCATE DESCRIPTOR 6.4.5.2 CALL 6.4.5.3 CLOSE 6.4.5.4 COMMIT 6.4.5.5 CONNECT 6.4.5.6 DEALLOCATE DESCRIPTOR 6.4.5.7 DECLARE CURSOR 6.4.5.8 DECLARE DATABASE 6.4.5.9 DECLARE STATEMENT 6.4.5.10 DELETE 6.4.5.11 DESCRIBE 6.4.5.12 DESCRIBE DESCRIPTOR 6.4.5.13 DISCONNECT 6.4.5.14 EXECUTE 6.4.5.15 EXECUTE DESCRIPTOR 6.4.5.16 EXECUTE...END EXEC 6.4.5.17 EXECUTE IMMEDIATE 6.4.5.18 FETCH 6.4.5.19 FETCH DESCRIPTOR 6.4.5.20 GET DESCRIPTOR 6.4.5.21 INSERT 6.4.5.22 OPEN 6.4.5.23 OPEN DESCRIPTOR 6.4.5.24 PREPARE 6.4.5.25 ROLLBACK 6.4.5.26 SAVEPOINT 6.4.5.27 SELECT 6.4.5.28 SET CONNECTION 6.4.5.29 SET DESCRIPTOR 6.4.5.30 UPDATE 6.4.5.31 WHENEVER 7 Open Client Library 7.1 Comparison with Oracle Call Interface 7.2 Compiling and Linking a Program 7.3 Ref Cursor Support 7.4 OCL Function Reference 7.4.1 Connect, Authorize and Initialize Functions 7.4.1.1 Using the tnsnames.ora File 7.4.2 Handle and Descriptor Functions 7.4.2.1 EDB_ATTR_HOLDABLE 7.4.2.2 EDB_ATTR_STMT_LVL_TX 7.4.3 Bind, Define and Describe Functions 7.4.4 Statement Functions 7.4.5 Transaction Functions 7.4.6 Date and Datetime Functions 7.4.7 Interval Functions 7.4.8 Number Functions 7.4.9 String Functions 7.4.10 Cartridge Services and File I/O Interface Functions 7.4.11 LOB Functions 7.4.12 Miscellaneous Functions 7.4.13 Supported Data Types 7.5 Debugger 7.5.1 Configuring the Debugger 7.5.2 Starting the Debugger 7.5.3 The View Data Options Window 7.5.4 Main Debugger Window 7.5.4.1 The Program Body Pane 7.5.4.2 The Stack Pane 7.5.4.3 The Output Pane 7.5.4.4 The Status Bar 7.5.5 Debugging a Program 7.5.5.1 Stepping Through the Code 7.5.5.2 Using Breakpoints 7.5.5.3 Setting a Global Breakpoint for In-Context Debugging 7.5.5.4 Exiting the Debugger 8 Performance Analysis and Tuning 8.1 Dynatune 8.1.1 edb_dynatune 8.1.2 edb_dynatune_profile 8.2 Infinite Cache 8.2.1 Installing Infinite Cache 8.2.2 Configuring the Infinite Cache Server 8.2.2.1 Modifying Infinite Cache Settings 8.2.2.2 Enabling Infinite Cache 8.2.2.3 Controlling the Infinite Cache Server 8.2.3 Dynamically Modifying Infinite Cache Server Nodes 8.2.4 Controlling the edb-icache Daemons 8.2.4.1 Command Line Options 8.2.4.2 edb-icache-tool 8.2.5 Warming the edb-icache Servers 8.2.5.1 The edb_icache_warm() Function 8.2.5.2 Using the edb_icache_warm Utility 8.2.6 Retrieving Statistics from Infinite Cache 8.2.6.1 Using edb_icache_stats() 8.2.6.2 edb_icache_server_list 8.2.7 Retrieving Table Statistics 8.2.7.1 pg_statio_all_tables 8.2.7.2 pg_statio_sys_tables 8.2.7.3 pg_statio_user_tables 8.2.7.4 pg_statio_all_indexes 8.2.7.5 pg_statio_sys_indexes 8.2.7.6 pg_statio_user_indexes 8.2.8 edb_icache_server_enable() 8.2.9 Infinite Cache Log Entries 8.2.10 Allocating Memory to the Cache Servers 8.3 Index Advisor 8.3.1 Index Advisor Components 8.3.2 Index Advisor Configuration 8.3.3 Using Index Advisor 8.3.3.1 Using the pg_advise_index Utility 8.3.3.2 Using Index Advisor at the psql Command Line 8.3.4 Reviewing the Index Advisor Recommendations 8.3.4.1 Using the show_index_recommendations() Function 8.3.4.2 Querying the index_advisor_log Table 8.3.4.3 Querying the index_recommendations View 8.3.5 Limitations 8.4 SQL Profiler 8.5 Query Optimization Hints 8.5.1 Default Optimization Modes 8.5.2 Access Method Hints 8.5.3 Specifying a Join Order 8.5.4 Joining Relations Hints 8.5.5 Global Hints 8.5.6 Using the APPEND Optimizer Hint 8.5.7 Conflicting Hints 8.6 DBMS_PROFILER 8.6.1 Querying the DBMS_PROFILER Tables and View 8.6.2 DBMS_PROFILER Functions and Procedures 8.6.2.1 FLUSH_DATA 8.6.2.2 GET_VERSION 8.6.2.3 INTERNAL_VERSION_CHECK 8.6.2.4 PAUSE_PROFILER 8.6.2.5 RESUME_PROFILER 8.6.2.6 START_PROFILER 8.6.2.7 STOP_PROFILER 8.6.3 DBMS_PROFILER - Reference 8.6.3.1 PLSQL_PROFILER_RUNS 8.6.3.2 PLSQL_PROFILER_UNITS 8.6.3.3 PLSQL_PROFILER_DATA 8.6.3.4 PLSQL_PROFILER_RAWDATA 8.7 Dynamic Runtime Instrumentation Tools Architecture (DRITA) 8.7.1 Configuring and Using DRITA 8.7.2 DRITA Functions 8.7.2.1 get_snaps() 8.7.2.2 sys_rpt() 8.7.2.3 sess_rpt() 8.7.2.4 sessid_rpt() 8.7.2.5 sesshist_rpt() 8.7.2.6 purgesnap() 8.7.2.7 truncsnap() 8.7.3 Simulating Statspack AWR Reports 8.7.3.1 edbreport() 8.7.3.2 stat_db_rpt() 8.7.3.3 stat_tables_rpt() 8.7.3.4 statio_tables_rpt() 8.7.3.5 stat_indexes_rpt() 8.7.3.6 statio_indexes_rpt() 8.7.4 Performance Tuning Recommendations 8.7.5 Event Descriptions 8.7.6 Catalog Views 8.7.6.1 edb$system_waits 8.7.6.2 edb$session_waits 8.7.6.3 edb$session_wait_history 9 Built-In Utility Packages 9.1 DBMS_ALERT 9.1.1 REGISTER 9.1.2 REMOVE 9.1.3 REMOVEALL 9.1.4 SIGNAL 9.1.5 WAITANY 9.1.6 WAITONE 9.1.7 Comprehensive Example 9.2 DBMS_CRYPTO 9.2.1 DECRYPT 9.2.2 ENCRYPT 9.2.3 HASH 9.2.4 MAC 9.2.5 RANDOMBYTES 9.2.6 RANDOMINTEGER 9.2.7 RANDOMNUMBER 9.3 DBMS_JOB 9.3.1 BROKEN 9.3.2 CHANGE 9.3.3 INTERVAL 9.3.4 NEXT_DATE 9.3.5 REMOVE 9.3.6 RUN 9.3.7 SUBMIT 9.3.8 WHAT 9.4 DBMS_LOB 9.4.1 APPEND 9.4.2 COMPARE 9.4.3 CONVERTTOBLOB 9.4.4 CONVERTTOCLOB 9.4.5 COPY 9.4.6 ERASE 9.4.7 GET_STORAGE_LIMIT 9.4.8 GETLENGTH 9.4.9 INSTR 9.4.10 READ 9.4.11 SUBSTR 9.4.12 TRIM 9.4.13 WRITE 9.4.14 WRITEAPPEND 9.5 DBMS_LOCK 9.5.1 SLEEP 9.6 DBMS_MVIEW 9.6.1 GET_MV_DEPENDENCIES 9.6.2 REFRESH 9.6.3 REFRESH_ALL_MVIEWS 9.6.4 REFRESH_DEPENDENT 9.7 DBMS_OUTPUT 9.7.1 CHARARR 9.7.2 DISABLE 9.7.3 ENABLE 9.7.4 GET_LINE 9.7.5 GET_LINES 9.7.6 NEW_LINE 9.7.7 PUT 9.7.8 PUT_LINE 9.7.9 SERVEROUTPUT 9.8 DBMS_PIPE 9.8.1 CREATE_PIPE 9.8.2 NEXT_ITEM_TYPE 9.8.3 PACK_MESSAGE 9.8.4 PURGE 9.8.5 RECEIVE_MESSAGE 9.8.6 REMOVE_PIPE 9.8.7 RESET_BUFFER 9.8.8 SEND_MESSAGE 9.8.9 UNIQUE_SESSION_NAME 9.8.10 UNPACK_MESSAGE 9.8.11 Comprehensive Example 9.9 DBMS_PROFILER 9.9.1 FLUSH_DATA 9.9.2 GET_VERSION 9.9.3 INTERNAL_VERSION_CHECK 9.9.4 PAUSE_PROFILER 9.9.5 RESUME_PROFILER 9.9.6 START_PROFILER 9.9.7 STOP_PROFILER 9.10 DBMS_RANDOM 9.10.1 INITIALIZE 9.10.2 NORMAL 9.10.3 RANDOM 9.10.4 SEED 9.10.5 SEED 9.10.6 STRING 9.10.7 TERMINATE 9.10.8 VALUE 9.10.9 VALUE 9.11 DBMS_RLS 9.11.1 ADD_POLICY 9.11.2 DROP_POLICY 9.11.3 ENABLE_POLICY 9.12 DBMS_SCHEDULER 9.12.1 Using Calendar Syntax to Specify a Repeating Interval 9.12.2 CREATE_JOB 9.12.3 CREATE_PROGRAM 9.12.4 CREATE_SCHEDULE 9.12.5 DEFINE_PROGRAM_ARGUMENT 9.12.6 DISABLE 9.12.7 DROP_JOB 9.12.8 DROP_PROGRAM 9.12.9 DROP_PROGRAM_ARGUMENT 9.12.10 DROP_SCHEDULE 9.12.11 ENABLE 9.12.12 EVALUATE_CALENDAR_STRING 9.12.13 RUN_JOB 9.12.14 SET_JOB_ARGUMENT_VALUE 9.13 DBMS_SQL 9.13.1 BIND_VARIABLE 9.13.2 BIND_VARIABLE_CHAR 9.13.3 BIND VARIABLE RAW 9.13.4 CLOSE_CURSOR 9.13.5 COLUMN_VALUE 9.13.6 COLUMN_VALUE_CHAR 9.13.7 COLUMN VALUE RAW 9.13.8 DEFINE_COLUMN 9.13.9 DEFINE_COLUMN_CHAR 9.13.10 DEFINE COLUMN RAW 9.13.11 DESCRIBE COLUMNS 9.13.12 EXECUTE 9.13.13 EXECUTE_AND_FETCH 9.13.14 FETCH_ROWS 9.13.15 IS_OPEN 9.13.16 LAST_ROW_COUNT 9.13.17 OPEN_CURSOR 9.13.18 PARSE 9.14 DBMS_UTILITY 9.14.1 LNAME_ARRAY 9.14.2 UNCL_ARRAY 9.14.3 ANALYZE_DATABASE, ANALYZE SCHEMA and ANALYZE PART_OBJECT 9.14.4 CANONICALIZE 9.14.5 COMMA_TO_TABLE 9.14.6 DB_VERSION 9.14.7 EXEC_DDL_STATEMENT 9.14.8 FORMAT_CALL_STACK 9.14.9 GET_CPU_TIME 9.14.10 GET_DEPENDENCY 9.14.11 GET_HASH_VALUE 9.14.12 GET_PARAMETER_VALUE 9.14.13 GET_TIME 9.14.14 NAME_TOKENIZE 9.14.15 TABLE_TO_COMMA 9.15 UTL_ENCODE 9.15.1 BASE64_DECODE 9.15.2 BASE64_ENCODE 9.15.3 MIMEHEADER_DECODE 9.15.4 MIMEHEADER_ENCODE 9.15.5 QUOTED_PRINTABLE_DECODE 9.15.6 QUOTED_PRINTABLE_ENCODE 9.15.7 TEXT_DECODE 9.15.8 TEXT_ENCODE 9.15.9 UUDECODE 9.15.10 UUENCODE 9.16 UTL_FILE 9.16.1 Setting File Permissions with utl_file.umask 9.16.2 FCLOSE 9.16.3 FCLOSE_ALL 9.16.4 FCOPY 9.16.5 FFLUSH 9.16.6 FOPEN 9.16.7 FREMOVE 9.16.8 FRENAME 9.16.9 GET_LINE 9.16.10 IS_OPEN 9.16.11 NEW_LINE 9.16.12 PUT 9.16.13 PUT_LINE 9.16.14 PUTF 9.17 UTL_HTTP 9.17.1 HTML_PIECES 9.17.2 REQ 9.17.3 RESP 9.17.4 BEGIN_REQUEST 9.17.5 END_REQUEST 9.17.6 END_RESPONSE 9.17.7 GET_BODY_CHARSET 9.17.8 GET_FOLLOW_REDIRECT 9.17.9 GET_HEADER 9.17.10 GET_HEADER_BY_NAME 9.17.11 GET_HEADER_COUNT 9.17.12 GET_RESPONSE 9.17.13 GET_RESPONSE_ERROR_CHECK 9.17.14 GET_TRANSFER_TIMEOUT 9.17.15 READ_LINE 9.17.16 READ_RAW 9.17.17 READ_TEXT 9.17.18 REQUEST 9.17.19 REQUEST_PIECES 9.17.20 SET_BODY_CHARSET 9.17.21 SET_FOLLOW_REDIRECT 9.17.22 SET_HEADER 9.17.23 SET_RESPONSE_ERROR_CHECK 9.17.24 SET_TRANSFER_TIMEOUT 9.17.25 WRITE_RAW 9.18 UTL_MAIL 9.18.1 SEND 9.18.2 SEND_ATTACH_RAW 9.18.3 SEND_ATTACH_VARCHAR2 9.19 UTL_SMTP 9.19.1 CONNECTION 9.19.2 REPLY/REPLIES 9.19.3 CLOSE_DATA 9.19.4 COMMAND 9.19.5 COMMAND_REPLIES 9.19.6 DATA 9.19.7 EHLO 9.19.8 HELO 9.19.9 HELP 9.19.10 MAIL 9.19.11 NOOP 9.19.12 OPEN_CONNECTION 9.19.13 OPEN_DATA 9.19.14 QUIT 9.19.15 RCPT 9.19.16 RSET 9.19.17 VRFY 9.19.18 WRITE_DATA 9.19.19 Comprehensive Example 9.20 UTL_URL 9.20.1 ESCAPE 9.20.2 UNESCAPE 10 Expanded Catalog Views 10.1 ALL_ALL_TABLES 10.2 ALL_CONS_COLUMNS 10.3 ALL_CONSTRAINTS 10.4 ALL_DB_LINKS 10.5 ALL_IND_COLUMNS 10.6 ALL_INDEXES 10.7 ALL_JOBS 10.8 ALL_OBJECTS 10.9 ALL_PART_KEY_COLUMNS 10.10 ALL_PART_TABLES 10.11 ALL_POLICIES 10.12 ALL_SEQUENCES 10.13 ALL_SOURCE 10.14 ALL_SUBPART_KEY_COLUMNS 10.15 ALL_SYNONYMS 10.16 ALL_TAB_COLUMNS 10.17 ALL_TAB_PARTITIONS 10.18 ALL_TAB_SUBPARTITIONS 10.19 ALL_TABLES 10.20 ALL_TRIGGERS 10.21 ALL_TYPES 10.22 ALL_USERS 10.23 ALL_VIEW_COLUMNS 10.24 ALL_VIEWS 10.25 DBA_ALL_TABLES 10.26 DBA_CONS_COLUMNS 10.27 DBA_CONSTRAINTS 10.28 DBA_DB_LINKS 10.29 DBA_IND_COLUMNS 10.30 DBA_INDEXES 10.31 DBA_JOBS 10.32 DBA_OBJECTS 10.33 DBA_PART_KEY_COLUMNS 10.34 DBA_PART_TABLES 10.35 DBA_POLICIES 10.36 DBA_ROLE_PRIVS 10.37 DBA_ROLES 10.38 DBA_SEQUENCES 10.39 DBA_SOURCE 10.40 DBA_SUBPART_KEY_COLUMNS 10.41 DBA_SYNONYMS 10.42 DBA_TAB_COLUMNS 10.43 DBA_TAB_PARTITIONS 10.44 DBA_TAB_SUBPARTITIONS 10.45 DBA_TABLES 10.46 DBA_TRIGGERS 10.47 DBA_TYPES 10.48 DBA_USERS 10.49 DBA_VIEW_COLUMNS 10.50 DBA_VIEWS 10.51 USER_ALL_TABLES 10.52 USER_CONS_COLUMNS 10.53 USER_CONSTRAINTS 10.54 USER_DB_LINKS 10.55 USER_IND_COLUMNS 10.56 USER_INDEXES 10.57 USER_JOBS 10.58 USER_OBJECTS 10.59 USER_PART_KEY_COLUMNS 10.60 USER_PART_TABLES 10.61 USER_POLICIES 10.62 USER_ROLE_PRIVS 10.63 USER_SEQUENCES 10.64 USER_SOURCE 10.65 USER_SUBPART_KEY_COLUMNS 10.66 USER_SYNONYMS 10.67 USER_TAB_COLUMNS 10.68 USER_TAB_PARTITIONS 10.69 USER_TAB_SUBPARTITIONS 10.70 USER_TABLES 10.71 USER_TRIGGERS 10.72 USER_TYPES 10.73 USER_USERS 10.74 USER_VIEW_COLUMNS 10.75 USER_VIEWS 10.76 V$VERSION 10.77 PRODUCT_COMPONENT_VERSION 11 System Catalog Tables 11.1 edb_dir 11.2 edb_all_resource_groups 11.3 edb_resource_group 11.4 edb_variable 11.5 pg_synonym 11.6 product_component_version 12 Appendix 12.1 Advanced Server Database Limits 12.2 Advanced Server Keywords
