# SQL Developer Examples
## DumpObjectTypesAction
A quick object action to dump the list of connection / objects types as INFO message in the log window. Plus one to show the selected object's connection / object type.

* ALERTLOG [Oracle DBA]
* ALIASES [DB2, DB2I]
* ANALYTIC VIEW [Oracle]
* ANALYTIC VIEW\_FOLDER [Oracle]
* APEX [Oracle]
* APEX\_FOLDER [Oracle]
* APEX\_PAGE [Oracle]
* APPLICATION [MIGPROJ, Oracle DBA]
* APPLICATIONS\_FOLDER [MIGPROJ]
* APPLICATION\_FILE [MIGPROJ]
* APPLICATION\_FILE\_FOLDER [MIGPROJ]
* APPPDB [Oracle DBA]
* APPROOT [Oracle DBA]
* APP\_FILE\_BINARY [MIGPROJ]
* APP\_FILE\_MODIFIED [MIGPROJ]
* APP\_FILE\_SCANNED [MIGPROJ]
* ARCHIVE\_LOGS [Oracle DBA]
* ARCHIVE\_LOGS\_FOLDER [Oracle DBA]
* ATTRIBUTE DIMENSION [Oracle]
* AUDITSETTING\_FOLDER [Oracle DBA]
* BABELFISH [Oracle DBA]
* BABELFISHTRANSLATOR [Oracle DBA]
* BABELFISHTRANSLATOR\_FOLDER [Oracle DBA]
* BABELFISH\_FOLDER [Oracle DBA]
* BACKUP\_JOB [Oracle DBA]
* BACKUP\_JOB\_FOLDER [Oracle DBA]
* BACKUP\_RECOVERY [Oracle DBA]
* BACKUP\_SET [Oracle DBA]
* BACKUP\_SET\_FOLDER [Oracle DBA]
* BLOCK [Oracle, TimesTen]
* CACHE GROUP [TimesTen]
* CACHE GROUP\_FOLDER [TimesTen]
* CALCMEASURE [Oracle]
* CALCMEASURE\_FOLDER [Oracle]
* CAPTURED\_OBJECTS\_FOLDER [MIGPROJ, MIGREPO, MIGREPOC]
* CATALOG [MIGPROJ, MIGREPO, MIGREPOC, Microsoft SQL Server, Sybase, Teradata]
* CATALOGS [MIGREPO, MIGREPOC]
* COLLECTION [MONGODB]
* COLUMN [Oracle]
* CONNECTION [ACCESS, Cloud, DB2, DB2I, Hive, JDBC, MIGPROJ, MIGREPO, MIGREPOC, MONGODB, Microsoft SQL Server, MySQL, ODBCBridge, Oracle, PostgreSQL, SDAmazonRedshift, SDPostgreSQL, Sybase, Teradata, TimesTen]
* CONSUMERGROUP [Oracle DBA]
* CONSUMERGROUPMAPPING [Oracle DBA]
* CONSUMERGROUPMAPPING\_FOLDER [Oracle DBA]
* CONSUMERGROUP\_FOLDER [Oracle DBA]
* CONTAINERRMPLAN [Oracle DBA]
* CONTAINERRMPLANITEM [Oracle DBA]
* CONTAINERRMPLAN\_FOLDER [Oracle DBA]
* CONTAINERRMSETTING\_FOLDER [Oracle DBA]
* CONTAINERRMSTATISTIC\_FOLDER [Oracle DBA]
* CONTROLFILE [Oracle DBA]
* CONTROLFILE\_FOLDER [Oracle DBA]
* CONVERTED\_MODELS\_FOLDER [MIGPROJ, MIGREPO, MIGREPOC]
* CUBE [Oracle]
* CUBE BUILD PROCESS [Oracle]
* CUBE DIMENSION [Oracle]
* CUBE DIMENSION\_FOLDER [Oracle]
* CUBEACL [Oracle]
* CUBEMEASURE [Oracle]
* CUBEMEASURE\_FOLDER [Oracle]
* CUBE\_FOLDER [Oracle]
* DATABASE LINK [Oracle]
* DATABASECONFIGURATION [Oracle DBA]
* DATABASEOBJECTS [Oracle DBA]
* DATAFILE [Oracle DBA]
* DATAFILE\_FOLDER [Oracle DBA]
* DATAGUARD\_FOLDER [Oracle DBA]
* DATAPUMP [Oracle DBA]
* DATAPUMP\_EXPORT\_JOBS [Oracle DBA]
* DATAPUMP\_EXPORT\_JOBS\_FOLDER [Oracle DBA]
* DATAPUMP\_IMPORT\_JOBS [Oracle DBA]
* DATAPUMP\_IMPORT\_JOBS\_FOLDER [Oracle DBA]
* DB\_INSTANCE\_FOLDER [Oracle DBA]
* DEFAULTS [Microsoft SQL Server, Sybase]
* DIMENSIONATTRIBUTE [Oracle]
* DIMENSIONHIERARCHY [Oracle]
* DIMENSIONLEVEL [Oracle]
* DIRECTORY [Oracle]
* DIRECTORY\_FOLDER [Oracle]
* EDITION\_SUBFOLDER [Oracle]
* EDITION\_TRIGGER [Oracle]
* EDITION\_VIEW [Oracle]
* FEATURES\_FOLDER [Oracle DBA]
* FUNCTION [Oracle, TimesTen]
* FUNCTIONS [DB2, DB2I, Microsoft SQL Server, MySQL, SDAmazonRedshift, SDPostgreSQL, Sybase, Teradata]
* FUNCTION\_FOLDER [Oracle, TimesTen]
* GDSREGION [Oracle DBA]
* GDSREGION\_FOLDER [Oracle DBA]
* GROUPS [Sybase]
* HCSAVMEASURE [Oracle]
* HCSCALCMEASURE [Oracle]
* HCSCALCMEASURE\_FOLDER [Oracle]
* HCSHIERARCHYLEVEL [Oracle]
* HCSVIEWDATA [Oracle]
* HIERARCHY [Oracle]
* IMAGE\_COPY [Oracle DBA]
* IMAGE\_COPY\_FOLDER [Oracle DBA]
* INDEX [DB2, DB2I, Microsoft SQL Server, MySQL, Oracle, SDAmazonRedshift, SDPostgreSQL, Sybase, Teradata, TimesTen]
* INDEX\_FOLDER [Oracle, TimesTen]
* JAVA [Oracle]
* JAVA\_FOLDER [Oracle]
* JOBS [Oracle]
* JOBS\_FOLDER [Oracle]
* LOGINS [Microsoft SQL Server]
* MACRO [Teradata]
* MATERIALIZED VIEW [Oracle, TimesTen]
* MATERIALIZED VIEW LOG [Oracle, TimesTen]
* MATERIALIZED VIEW LOG\_FOLDER [TimesTen]
* MATERIALIZED VIEW\_FOLDER [Oracle, TimesTen]
* MD\_COLUMNS [MIGREPO, MIGREPOC]
* MD\_INDEX [MIGREPO, MIGREPOC]
* MD\_PACKAGE [MIGREPOC]
* MD\_SEQUENCE [MIGREPOC]
* MD\_TABLE [MIGREPO, MIGREPOC]
* MEASURE FOLDER [Oracle]
* MEASURE FOLDER\_FOLDER [Oracle]
* METRICS\_INSTANCE\_FOLDER [Oracle DBA]
* METRICS\_MONITOR\_FOLDER [Oracle DBA]
* METRICS\_SAMPLE\_FOLDER [Oracle DBA]
* METRICS\_TABLE\_FOLDER [Oracle DBA]
* MIGRATION\_PROJECT [MIGPROJ, MIGREPO, MIGREPOC]
* MIGRATION\_PROJECTS\_FOLDER [MIGPROJ, MIGREPO, MIGREPOC]
* Make Tablespace Locally Managed [Oracle DBA]
* OLAPACL [Oracle]
* OLAPAW [Oracle]
* OLAPAW\_FOLDER [Oracle]
* OLAPDMLPROGRAM [Oracle]
* OLAPDMLPROGRAM\_FOLDER [Oracle]
* OLAPJOBHISTORY [Oracle]
* OLAPJOBRUNNING [Oracle]
* OLAPJOBSCHEDULED [Oracle]
* OLAPJOBSLAVE [Oracle]
* PACKAGE [Oracle, TimesTen]
* PACKAGE BODY [Oracle, TimesTen]
* PACKAGE\_FOLDER [Oracle, TimesTen]
* PACKAGE\_PARENT [Oracle, TimesTen]
* PARAMETERS\_FOLDER [Oracle DBA]
* PDB [Oracle DBA]
* PDB\_FOLDER [Oracle DBA]
* PERFORMANCE\_ADDMTASK [Oracle DBA]
* PERFORMANCE\_ADDMTASK\_FOLDER [Oracle DBA]
* PERFORMANCE\_ASH\_FOLDER [Oracle DBA]
* PERFORMANCE\_AWR [Oracle DBA]
* PERFORMANCE\_AWR\_FOLDER [Oracle DBA]
* PERFORMANCE\_BASELINE [Oracle DBA]
* PERFORMANCE\_BASELINETEMPLATE [Oracle DBA]
* PERFORMANCE\_BASELINETEMPLATE\_FOLDER [Oracle DBA]
* PERFORMANCE\_BASELINE\_FOLDER [Oracle DBA]
* PERFORMANCE\_PDB\_ASH\_FOLDER [Oracle DBA]
* PERFORMANCE\_PDB\_AWR [Oracle DBA]
* PERFORMANCE\_SNAPSHOT [Oracle DBA]
* PERFORMANCE\_SNAPSHOT\_FOLDER [Oracle DBA]
* PROCEDURE [Oracle, TimesTen]
* PROCEDURES [DB2, DB2I, Microsoft SQL Server, MySQL, SDAmazonRedshift, SDPostgreSQL, Sybase, Teradata]
* PROCEDURE\_FOLDER [Oracle, TimesTen]
* PROFILE [Oracle DBA]
* PROFILE\_FOLDER [Oracle DBA]
* PROPERTIES\_FOLDER [Oracle DBA]
* PUBLIC DATABASE LINK [Oracle]
* PUBLIC\_SYNONYM [Oracle, TimesTen]
* PUBLIC\_SYNONYM\_FOLDER [Oracle, TimesTen]
* QUEUE [Oracle]
* QUEUE TABLE [Oracle]
* RDFBULKLOADTRACE [Oracle]
* RDFBULKLOADTRACE\_FOLDER [Oracle]
* RDFDATATYPEINDEX [Oracle]
* RDFDATATYPEINDEX\_FOLDER [Oracle]
* RDFENTAILMENT [Oracle]
* RDFENTAILMENT\_FOLDER [Oracle]
* RDFGRAPH [Oracle]
* RDFGRAPHMODEL [Oracle]
* RDFINDEX [Oracle]
* RDFINDEX\_FOLDER [Oracle]
* RDFREGULARMODEL [Oracle]
* RDFRULEBASE [Oracle]
* RDFRULEBASE\_FOLDER [Oracle]
* RDFVIEW [Oracle]
* RDFVIEW\_FOLDER [Oracle]
* RDFVIRTUALMODEL [Oracle]
* RDFVIRTUALMODEL\_FOLDER [Oracle]
* REALM CONSTRAINT [Oracle]
* REALM CONSTRAINT\_FOLDER [Oracle]
* RECYCLEBIN [Oracle]
* REDOLOGGROUP [Oracle DBA]
* REDOLOGGROUPMEMBER [Oracle DBA]
* REDOLOGGROUP\_FOLDER [Oracle DBA]
* REPLICATION [TimesTen]
* RESOURCEMANAGERPLAN [Oracle DBA]
* RESOURCEMANAGERPLANITEM [Oracle DBA]
* RESOURCEMANAGERPLAN\_FOLDER [Oracle DBA]
* RESOURCEMANAGERSETTING\_FOLDER [Oracle DBA]
* RESOURCEMANAGERSTATISTIC\_FOLDER [Oracle DBA]
* RESTORE\_POINT [Oracle DBA]
* RESTORE\_POINT\_FOLDER [Oracle DBA]
* REST\_HANDLER [Oracle]
* REST\_MODULE [Oracle]
* REST\_MODULE\_FOLDER [Oracle]
* REST\_PARAMETER [Oracle]
* REST\_PRIVILEGE [Oracle]
* REST\_PRIVILEGE\_FOLDER [Oracle]
* REST\_ROLE [Oracle]
* REST\_ROLE\_FOLDER [Oracle]
* REST\_TEMPLATE [Oracle]
* RMAN\_SETTINGS\_FOLDER [Oracle DBA]
* ROLE [Oracle DBA]
* ROLEGRANTEDROLE [Oracle DBA]
* ROLEGRANTEDSYSPRIV [Oracle DBA]
* ROLE\_FOLDER [Oracle DBA]
* ROLLBACK\_SEGMENT [Oracle DBA]
* ROLLBACK\_SEGMENT\_FOLDER [Oracle DBA]
* RULES [Microsoft SQL Server, Sybase]
* SCHCHAIN [Oracle]
* SCHCHAIN\_FOLDER [Oracle]
* SCHCREDENTIAL [Oracle]
* SCHCREDENTIAL\_FOLDER [Oracle]
* SCHDBDESTGROUP [Oracle]
* SCHDBDESTGROUP\_FOLDER [Oracle]
* SCHDBDESTINATION [Oracle]
* SCHDBDESTINATION\_FOLDER [Oracle]
* SCHEDULED\_RMAN\_ACTION [Oracle DBA]
* SCHEDULED\_RMAN\_ACTION\_FOLDER [Oracle DBA]
* SCHEDULER [Oracle]
* SCHEMA [Oracle]
* SCHEXDESTGROUP [Oracle]
* SCHEXDESTGROUP\_FOLDER [Oracle]
* SCHEXDESTINATION [Oracle DBA]
* SCHFILEWATCHER [Oracle]
* SCHFILEWATCHER\_FOLDER [Oracle]
* SCHJOBCLASS [Oracle DBA]
* SCHJOBCLASS\_FOLDER [Oracle DBA]
* SCHJOB\_FOLDER [Oracle]
* SCHNEWJOB [Oracle]
* SCHNEWJOB\_FOLDER [Oracle]
* SCHPROGRAM [Oracle]
* SCHPROGRAM\_FOLDER [Oracle]
* SCHSCHEDULE [Oracle]
* SCHSCHEDULERATTRIBUTES\_FOLDER [Oracle DBA]
* SCHSCHEDULE\_FOLDER [Oracle]
* SCHWINDOW [Oracle DBA]
* SCHWINDOWGROUP [Oracle DBA]
* SCHWINDOWGROUP\_FOLDER [Oracle DBA]
* SCHWINDOW\_FOLDER [Oracle DBA]
* SEGMENTS [Sybase]
* SEQUENCE [DB2I, Oracle, TimesTen]
* SHARD [Oracle DBA]
* SHARDGRID\_FOLDER [Oracle DBA]
* SHARDGROUP [Oracle DBA]
* SHARDGROUP\_FOLDER [Oracle DBA]
* SHARDSPACE [Oracle DBA]
* SHARDSPACE\_FOLDER [Oracle DBA]
* SHARD\_FOLDER [Oracle DBA]
* SQL\_MONITOR\_FOLDER [Oracle DBA]
* STATUS\_FOLDER [Oracle DBA]
* SYNONYM [Microsoft SQL Server, Oracle, TimesTen]
* SYNONYM\_FOLDER [Oracle, TimesTen]
* SYSTEMTABLE [Sybase]
* TABLE [ACCESS, Cloud, DB2, DB2I, Hive, JDBC, Microsoft SQL Server, MySQL, Oracle, SDAmazonRedshift, SDPostgreSQL, Sybase, Teradata, TimesTen]
* TABLESPACE [Oracle DBA]
* TABLESPACE\_FOLDER [Oracle DBA]
* TABLE\_FOLDER [Hive, Oracle, TimesTen]
* TRIGGE [Microsoft SQL Server]
* TRIGGER [Oracle]
* TRIGGERS [DB2, DB2I, Microsoft SQL Server, MySQL, SDAmazonRedshift, SDPostgreSQL, Sybase, Teradata]
* TRIGGER\_FOLDER [Oracle]
* TT\_GROUPS [Oracle DBA]
* TT\_GROUPS\_FOLDER [Oracle DBA]
* TUNING\_MEMORY\_FOLDER [Oracle DBA]
* TYPE [Oracle]
* TYPE BODY [Oracle]
* TYPE\_FOLDER [Oracle]
* UDATATYPES [Microsoft SQL Server]
* UNDOS\_FOLDER [Oracle DBA]
* USER [MIGPROJ, MIGREPO, MIGREPOC, MySQL, Oracle, Oracle DBA, PostgreSQL, TimesTen]
* USERGRANTEDROLE [Oracle DBA]
* USERGRANTEDSYSPRIV [Oracle DBA]
* USERS [Microsoft SQL Server, Sybase]
* USER\_FOLDER [Oracle, Oracle DBA, TimesTen]
* UTYPES [DB2, DB2I, Sybase]
* VIEW [DB2, DB2I, Microsoft SQL Server, MySQL, Oracle, SDAmazonRedshift, SDPostgreSQL, Sybase, Teradata, TimesTen]
* VIEW\_COLUMN [Oracle]
* VIEW\_FOLDER [Oracle, TimesTen]
* XDB [Oracle]
* XDB\_SUBFOLDER [Oracle]
* XML SCHEMA [Oracle]
