Index

A  B  C  D  E  F  G  H  I  J  L  M  N  O  P  Q  R  S  T  U  V  W  X  

A

  • About Database Project Folders and Project Items 10.3
  • About Oracle Database Project 9.1
  • About Oracle Database Project Version 2 10.1
  • about Oracle Performance Analyzer 13.2
  • Add database reference 4.27
  • Add Import Function
  • Adding Database References 9.2.1
  • ADDM Task Nodes 3.83
  • ADDM Tasks Node 3.84
  • Advanced Properties Dialog Box 4.2.3
  • advance queues node 3.74
  • associating connections with Server Explorer 9.7, 10.7
  • autocommit
  • Automatic code generation
    • OracleDataAdapter Wizard 4.19
  • available database connections 7.3.3
  • AWR Snapshot Nodes 3.86
  • AWR Snapshots Node 3.85

B

C

  • call stack
  • call stack window 7.12, 7.12.2
  • CDBs 16.1
  • Clone Pluggable Database Dialog 4.38
  • Close Pluggable Database Dialog 4.42
  • Collection Filter Dialog 4.2.4
  • Collection HTTPS Proxy Dialog 4.2.5
  • collection nodes
    • filtering 3.7.1
    • limiting number of objects 3.7.5
  • common PL/SQL debugger operations 7.8
  • compatibility
  • compile command 7.2.2
  • compile debug command 7.2, 7.2.2
  • compile debug option
  • compiler settings 6.4.1
  • compiling a PL/SQL program for debugging 7.2.2
  • composite type parameters
    • as IN or INOUT parameters 7.5.2
  • Connecting to Oracle Database from Visual Studio 2.2
  • Connection Configuration Options 4.2.6
  • Connection Configuration Options Page 4.2.6
  • connection dialog box
  • Connection dialog box 2.2, 4.2
  • constraints in Oracle Developer Tools 3.25
  • continuing debug execution 7.10.3
  • controlling PL/SQL program execution 7.10
  • creating a new ADDM Task 4.33
  • creating roles
    • in Oracle Developer Tools 12.3
  • Creating the Oracle Database Project 9.2
  • Creating the Oracle Database Project Version 2 10.2
  • creating users
    • in Oracle Developer Tools 12.2
  • custom class wizard 4.20

D

  • Database Connection 4.45.2
  • database project folders 9.5, 10.5
  • Database Reference Nodes 9.8
  • Database Reference Project Items 10.8
  • Database References 9.7, 10.7
  • data connection nodes 3.14
  • data connections in Oracle Developer Tools 3.13
    • about 3.13
    • creating in Data Connection dialog box 4.2
    • node (child) 3.14
    • node (parent) 3.13
  • Data Connections options page 3.12
  • Data Window
    • General Options page 5.2
  • DBMS_DEBUG_JDWP package 7.7, 7.7.4
  • debug
  • DEBUG ANY PROCEDURE privilege 7.2.1
  • DEBUG CONNECT SESSION privilege 7.2.1
  • debugger modes
    • direct database debugging mode 7.4
    • external application debugging mode 7.4
    • multitier application debugging mode 7.4
    • Oracle PL/SQL Debugger 7.4
  • debugging .NET application 7.6.1
  • debug information 7.2, 7.2.2
  • debug options page
  • debug privileges for databases 7.2.1
  • debug requirements for databases 7.2.1
  • defined connection mechanisms 7.7
  • deleting roles
    • in Oracle Developer Tools 12.3
  • deleting users
    • Oracle Developer Tools 12.2
  • deployment script 15.1
  • diff script 15.1
  • direct database debugging mode 7.4, 7.5
  • dirty programs 7.9
  • dropping nodes in Oracle Developer Tools 3.2
  • DROP USER command
    • using in Oracle Developer Tools 12.2

E

  • easy connect naming 4.2
  • entity data model
  • Entity Designer 14.3
  • Entity Framework 14.1
  • Entity Framework Designer requirements 14.2
  • Entity Function
  • entity model
  • exceptions 7.13
  • execution plan
    • examining 8.4
  • Explain Plan
    • using in the Oracle Query Window 13.6
  • EXPLAIN PLAN in Oracle Query Window 8.4.1
  • external application debugging mode 7.4, 7.7
    • breakpoints 7.7.5
    • how it works 7.7.1
    • requirements 7.7.4
    • using ORA_DEBUG_JDWP environment variable 7.7.6
  • EZ Connect 4.2
  • EZ Connect naming 4.2.2

F

  • filtering collection nodes 3.7.1
  • filtering collection nodes in Server Explorer 4.2.4
  • Filter tab 4.2.4
  • folder 9.5, 10.5
  • Function Designer 4.9
  • function nodes 3.45
  • function return value node 3.47
  • functions in Oracle Developer Tools 3.44, 3.47
    • about 3.44
    • compiling 4.11
    • creating in Function Designer 4.9
    • editing in PL/SQL Code Editor 4.9
    • generating .sql creation script 3.45
    • naming conventions 4.1.2
    • node (parent) 3.44
    • nodes (child) 3.45
    • running 4.11
  • functions node 3.44

G

  • General options page 5.2
  • generating
  • generating classes with Oracle Custom Class Wizard 4.20.3
  • generating database create script 14.3.3
  • GRANT DEBUG CONNECT SESSION privilege 7.2.1
  • Granting and Revoking Privileges Wizards 4.24
  • granting privileges
    • in Oracle Developer Tools 12.4

H

  • handling PL/SQL exceptions 7.13
  • HTTPS Proxy tab 4.2.5

I

  • Import Schema Dialog 4.45, 4.45.1
  • Import table wizard 4.6
  • indexes in Oracle Developer Tools 3.27
    • about 3.27
    • creating in Table Designer 4.5
    • editing in Table Designer 4.5
    • naming conventions 4.1.2
    • node (parent) 3.27
    • nodes (child) 3.28
  • indexes node 3.27
  • index nodes 3.28
  • Integration with Query Designer 4.21
  • IntelliSense Settings Options
  • IP address 7.7.2

J

  • Java classes in Oracle Developer Tools 3.61
  • Java classes node 3.61
  • Java class nodes 3.62

L

  • limiting number of objects

M

  • Managed Driver 4.2.2
  • managing roles
    • in Oracle Developer Tools 12.3
  • managing script files 9.9, 10.9
  • managing users
    • in Oracle Developer Tools 12.2
  • mapping an Entity Function 14.3.4
  • master SQL script 9.9.4.1
  • Microsoft Entity Framework 14.1
  • Microsoft Query Designer 4.21
  • modifying roles
    • in Oracle Developer Tools 12.3
  • modifying users
    • in Oracle Developer Tools 12.2
  • Multitenant Container Databases 16.1
  • multitier application debugging mode 7.4, 7.6

N

  • naming conventions for nodes 3.4
  • naming conventions for schema objects 4.1.2
  • Nested Table Type Designer 4.18
  • nested table type nodes 3.73
  • New ADDM Task dialog 4.33
  • New AWR Snapshot dialog 4.34
  • New Pluggable Database Dialog 4.37
  • nodes
    • naming conventions 3.4
    • refreshing 3.5
    • visibility in Server Explorer 3.7.4
    • visibility of collection types 3.7.4
  • nodes in Oracle Developer Tools 3.2
    • about (general) 3.2
    • about (user ownership) 3.13
    • advance queues node 3.74
    • Constraint Nodes 3.26
    • Constraints Node 3.25
    • Data Connection Nodes 3.14
    • Data Connections Node 3.13
    • dropping 3.2
    • Function Node 3.45
    • Functions Node 3.44
    • Indexes Node 3.27
    • Index Nodes 3.28
    • Java Classes Node 3.61
    • Java Class Node 3.62
    • nested table type nodes 3.73
    • object type attribute nodes 3.70
    • object type body nodes 3.69
    • object type nodes 3.68
    • Package Body Node 3.52
    • Package Nodespackages in Oracle Developer Tools
      • generating .sql creation script for package 3.49
    • Packages Node 3.48
    • Package Specification Function Node 3.50
    • Package Specification Procedures Node 3.51
    • Parameter Nodes for Procedure, Functions, Packages Methods, and Object Type Methods 3.53
    • Parameter Nodes for Procedures, Functions, Package Methods and Object Type Methods 3.46
    • Procedure Nodes 3.43
    • Procedures Node 3.42
    • Progation Nodes 3.80
    • progations node 3.79
    • Queue Nodes 3.76
    • queues node 3.75
    • queue tables 3.81
    • refreshing 3.5
    • Sequence Nodes 3.57
    • Sequences Node 3.56
    • Subscriber Nodes 3.78
    • subscribers node 3.77
    • Synonym Nodes 3.55
    • Synonyms Node 3.54
    • Table Node 3.23
    • Tables Node 3.19
    • Trigger Node 3.34
    • Triggers Node 3.29
    • XML database node 3.58
    • XML Schema Nodes 3.60
    • XML Schemas Node 3.59
  • non-CDBs 16.1

O

  • object and schema view in Oracle Developer Tools 12.1.3
  • Object-Relational Mapping (ORM) technology 14.1
  • object type attribute nodes 3.70
  • object type body nodes 3.69
  • Object Type Designer 4.16
  • object type nodes 3.68
  • object view 3.4
  • Open Pluggable Database Dialog 4.41
  • options pages
    • Oracle Developer Tools 2.3
  • ORA_DEBUG_JDWP environment variable 7.7, 7.7.1, 7.7.4
  • Oracle .NET Developer Center 1.3
  • Oracle Custom Class Wizard 4.20
  • OracleDataAdapter Wizard 4.19
  • Oracle Database (ODP.NET, Managed Driver) 4.2.2
  • Oracle Database project
  • Oracle Database Project 9.2
    • running a script from 9.13.2
    • running a script outside 9.13.4
  • Oracle Database Project Add Database Reference 4.27
  • Oracle Database Project Folders 9.5, 10.5
  • Oracle Database Project Node 9.4
  • Oracle Database Project nodes and folders 9.3
  • Oracle Database Project Run On 4.26
  • Oracle Database Project Version 2 10.2
  • Oracle Database Project Version 2 Project Folder 10.4
  • Oracle Data Window 5.1
  • Oracle Developer Tools
    • functionality 1.1.1
    • options pages 2.3
    • setting up 2.1
    • Users and Roles Management feature 12.1
  • OracleJVM option 3.61
  • OracleMetaLink 1.3
  • Oracle Performance Analyze 13.2
  • Oracle Performance Analyzer
  • Oracle Performance Tuner
    • steps to using 13.4
  • Oracle PL/SQL Debugger
    • about 7.1
    • debugger modes 7.4
  • Oracle Query Window 8.1
  • Oracle related documentation 1.3
  • Oracle requirements for Oracle Developer Tools 1.2
  • Oracle Server Login 4.3
  • Oracle SQL Editor
  • Oracle SQL script compatibility requirements 9.9.1, 10.9.1
  • Oracle SQL script editor 9.12, 10.11, 9.13.3, 10.12.3
  • Oracle SQL scripts
  • Oracle Steams AQ Queues 4.28, 4.30
  • Oracle Store 1.3
  • Oracle Technology Network 1.3
  • ORM (Object-Relational Mapping) 14.1
  • OTN 1.3
  • output window 7.12

P

  • package body nodes 3.52
  • Package Designer
    • see also packages in Oracle Developer Tools 4.12
  • package function nodes 3.50
  • package nodes 3.49
  • package procedure nodes 3.51
  • packages in Oracle Developer Tools 3.48
    • about 3.48
    • creating in Package Designer 4.12
    • editing in PL/SQL Code Editor 4.12
    • generating .sql creation script for package body 3.52
    • naming conventions 4.1.2
    • node (parent) 3.48
    • node (parent body node) 3.52
    • node (parent specification function) 3.50
    • node (parent specification stored procedure) 3.51
    • nodes (child) 3.49
  • packages node 3.48
  • parameterized SQL and PL/SQL 8.1.2.6
  • parameterized SQL or PL/SQL 4.43
  • parameter nodes 3.46
  • passwords in code examples
  • Performance Analyzer
  • performance tuning
  • PL/SQL Code Editor 6.1
    • about 6.1
    • built-in tools 6.3
    • getting help on commands 6.3
    • multibyte characters 6.3.1
    • saving work 6.1
    • starting 6.2
    • syntax coloring 6.3.1
  • PL/SQL compiler settings 6.4, 6.4.1
  • PL/SQL debugging
  • PL/SQL debugging options 7.3
  • PL/SQL exceptions 7.13
  • PL/SQL programs
    • refresh behavior 7.9
  • PL/SQL queries
    • executing 8.1
  • PL/SQL source location 7.3
  • pluggable databases 16.1
  • Pluggable Databases
    • connecting in Server Explorer 16.3
  • Plug Pluggable Database Dialog 4.39
  • Preview SQL Dialog 4.4
  • privileges
    • DEBUG ANY PROCEDURE 7.2.1
    • DEBUG CONNECT SESSION 7.2.1
    • GRANT DEBUG CONNECT SESSION 7.2.1
    • granting in Oracle Developer Tools 12.4
    • Oracle Developer Tools 12.1.2
  • Privileges 13.2
  • problems debugging 7.14
  • problems setting breakpoints 7.14
  • Procedure Designer 4.10
  • procedure nodes 3.43
  • procedures in Oracle Developer Tools 3.42
    • about 3.42
    • compiling 4.11
    • creating in Procedure Designer 4.10
    • editing in Procedure Designer 4.10
    • generating .sql creation script 3.42
    • naming conventions 4.1.2
    • node (parent) 3.42
    • nodes (child) 3.42
    • nodes (parameter) 3.53
  • procedures node 3.42
  • progation nodes 3.80
  • progation nodes in Oracle Developer Tools
    • nodes (child) 3.80
  • progations node 3.79
  • program execution 7.10
  • project script files 9.6, 10.6

Q

  • Query Designer 4.21
  • Query Parameters Dialog 4.43
  • Query Window
    • General Options page 5.2
    • tuning SQL 8.3
  • Query Window options page 8.6
  • Queue Designer 4.30
  • queue in Oracle Developer Tools
    • nodes (child) 3.76
  • queue nodes 3.76
  • queues node 3.75
  • Queue Table Designer 4.28
  • queue table nodes 3.82
  • queue tables node 3.81
  • quickwatch window 7.12

R

  • REF CURSOR metadata 4.11, 14.3.4
  • refresh behavior
    • PL/SQL programs 7.9
  • refreshing nodes in Oracle Developer Tools 3.5
  • related documentation 1.3
  • requirements
  • requirements for Oracle Developer Tools 1.2
  • requirements for using Entity Framework Designer 14.2
  • return values 3.47
  • Role Designer 4.23
  • role nodes 3.67
  • roles node 3.66
  • run dialog box 4.11
  • running a script from Oracle Database Project 9.13.2
  • running a script from Oracle Database Project Version 2 10.12.2
  • running a script from Oracle SQL script editor 9.13.3, 10.12.3
  • running a script outside Oracle Database Project 9.13.4
  • running a script outside Oracle Database Project Version 2 10.12.4
  • running Oracle SQL scripts 9.13, 10.12
  • running to the cursor location 7.10.6
  • Run SQL*Plus Script 4.25

S

  • schema and object view in Oracle Developer Tools 12.1.3
  • Schema Compare
  • Schema Compare Results Window 4.36
  • Schema Compare Source and Target Dialog 4.35
  • schemas 3.17
    • node (parent) 3.17
    • nodes (child) 3.18
    • schema objects 3.2
  • schemas, about (Oracle Developer Tools) 3.17
  • schema view 3.4
  • scripts and source control 9.6, 10.6
  • Sequence Designer 4.13
  • sequence nodes 3.57
  • sequences
    • creating in Sequence Designer 4.13
    • node (parent) 3.56
    • nodes (child) 3.57
  • sequences, about (Oracle Developer Tools) 3.56
  • sequences, generating .sql creation script 3.57
  • sequences node 3.56
  • Server Explorer
    • about 3.1
    • setting PL/SQL compiler settings 6.4
  • Server Explorer integration 3.2
    • what is it? 3.3
  • Server Explorer nodes
    • ADDM task nodes 3.83, 3.84
    • AWR snapshot nodes 3.86
    • AWR snapshots node 3.85
    • Data Connections options page 3.12
    • filtering the displayed schema 3.7.2
    • operations on multiple database objects 3.6
    • performance problems avoidng 3.7, 3.8, 3.9, 3.10, 3.11
    • queue table nodes 3.82
    • queue tables node 3.81
    • role nodes 3.67
    • roles node 3.66
    • user nodes 3.65
    • visibility of collection types 3.7.4
  • Server Explorer nodesfiltering public schemas 3.7.3
  • setting Oracle SQL Editor as default 9.12.2, 10.11.2
  • source control integration 9.10, 10.10
  • source location
  • SQL*Plus 9.9, 10.9
  • sql files 9.9, 10.9
  • sqlnet.ora file 4.2
  • SQL queries
    • executing 8.1
  • SQL scripts 9.13, 10.12
  • SQL statement
    • examining execution plan 8.4
    • executing 8.1.2
  • SQL Tuning Advisor
  • starting problems 7.14
  • starting the Oracle PL/SQL debugger 7.10.1
  • step into 7.5, 7.10.2
  • step out 7.10.2
  • step over 7.10.2
  • stepping through a PL/SQL program 7.10.2
  • stopping debug processing 7.10.4
  • Stored Procedure Run Dialog Box 4.11
  • subscriber nodes 3.78
  • subscriber nodes in Oracle Developer Tools
    • nodes (child) 3.78
  • subscribers node 3.77
  • Synonym Designer 4.14
  • synonym nodes 3.55
  • synonyms in Oracle Developer Tools
    • about 3.54
    • creating in Synonym Designer 4.14
    • editing in Synonym Designer 4.14
    • generating .sql creation script 4.14
    • node (parent) 3.54
    • nodes (child) 3.55
  • synonyms node 3.54
  • SYSDBA user
    • viewing in Server Explorer 12.1.3

T

  • table column node 3.24
  • Table Designer 4.5
  • table nodes 3.23
  • table-per-hierarchy 14.3.3
  • table-per-type 14.3.3
  • tables in Oracle Developer Tools
    • about 3.19, 3.23
    • creating in Table Designer 4.5
    • editing in Table Designer 4.5
    • generating .sql creation script 3.23
    • node (column) 3.24
    • node (parent) 3.19
    • node (parent constraint) 3.25
    • nodes (child) 3.23
    • nodes (child constraint) 3.26
    • storage options 4.5.9
  • tables node 3.19
  • TCP port number 7.7.1, 7.7.2, 7.7.4
    • default range 7.3
    • for debugging 7.3
    • starting, ending 7.3.3
  • threads window 7.12
  • TNS Connection 4.2
  • tnsnames.ora file 4.2
  • Trigger Designer 4.7
  • Trigger Dialog Box
    • see also triggers in Oracle Developer Tools 4.7
  • trigger nodes 3.34
  • triggers in Oracle Developer Tools
    • about 3.29, 4.7
    • creating in Trigger Designer 4.7
    • creating on views 4.8
    • editing in PL/SQL Code Editor 4.7
    • naming conventions 4.1.2
    • node (child) 3.34
    • node (parent) 3.29
  • triggers node 3.29
  • troubleshooting 7.14
  • tuning SQL in Query Window 8.3

U

  • Unmanaged Driver 4.2.2
  • Unplug Pluggable Database Dialog 4.40
  • updating
  • user-defined types node 3.63
  • User Designer 4.22
  • users 3.64
    • managing in Oracle Developer Tools 12.2
    • node (parent) 3.64
    • nodes (child) 3.65
  • users, about (Oracle Developer Tools) 3.64
  • users, roles, and privileges
  • users and roles
  • Users and Roles Management feature
    • Oracle Developer Tools 12.1
  • using breakpoints 7.11

V

  • Varray Designer 4.17
  • view column node 3.41
  • View Designer 4.8
  • viewing 7.12.2
  • Viewing Oracle Database Project in Solution Explorer 9.2.2
  • Viewing Oracle Database Project Version 2 in Solution Explorer 10.2.1
  • viewing output window 7.12.4
  • view nodes 3.40
  • views in Oracle Developer Tools 3.35
    • about 3.35
    • creating in View Designer 4.8
    • creating triggers on views 4.8.4
    • generating .sql creation script 3.40
    • naming conventions 4.1.2
    • node (parent) 3.35
    • node (parent column) 3.41
    • nodes (child) 3.40
  • views node 3.35
  • Visual Studio 3.1
  • Visual Studio Entity Designer 14.3

W

  • watch windows 7.12
  • wizards and designers in Oracle Developer Tools
    • Add Trigger Dialog Box 4.7
    • Connection Dialog Box 4.2
    • Function Designer 4.9
    • Granting and Revoking Privileges Wizards 4.24
    • Import table wizard 4.6
    • Nested Table Type Designer 4.18
    • Object Type Designer 4.16
    • Oracle Custom Class Wizard 4.20
    • OracleDataAdapter Wizard 4.19
    • Oracle Database Project Add Database Reference 4.27
    • Oracle Database Project Run On 4.26
    • Package Designer 4.12
    • Procedure Designer 4.10
    • Queue Designer 4.30
    • Queue Table Designer 4.28
    • Role Designer 4.23
    • Run Dialog Box 4.11
    • Run SQL*Plus Script 4.25
    • Sequence Designer 4.13
    • Synonym Designer 4.14
    • Table Designer 4.5
    • User Designer 4.22
    • Varray Designer 4.17
    • View Designer 4.8
    • XML Schema Designer 4.15

X

  • XML database node 3.58
    • see also XML schemas in Oracle Developer Tools 3.58
  • XML Schema Designer 4.15
  • XML schema nodes 3.60
  • XML schemas in Oracle Developer Tools 3.59
    • about 3.59
    • creating in XML Schema Designer 4.15
    • node (database) 3.58
    • node (parent) 3.59
    • nodes (child) 3.60
    • schemas 3.17
  • XML schemas node 3.59