Skip to content

Oracle PL/SQL Tutorial

Learn Oracle SQL

  • Home
  • Joins
    • Inner Join
    • Left Join
    • Right Join
    • Self Join
    • Full Join
  • Constraints
    • Add primary key
    • Add constraint foreign key
    • Drop constraint key
    • Enable a foreign key
    • Disable foreign key
  • Cursors
  • Triggers
  • Indexes
    • Create index oracle
    • Alter index oracle
    • Drop index oracle
    • List all indexes from Oracle database
  • Interview Questions

Data Dictionary examples

Data Dictionary examples

  • List all tables from a schema of Oracle database
  • List all procedures from a schema of Oracle database
  • List all triggers from Oracle database
  • List all indexes from Oracle database
  • Display names of all constraints from Oracle database
  • Display names of all sequences from Oracle database
  • Display names of all views from Oracle database
  • Get names of all tablespaces from Oracle database
  • Get names of all synonyms from Oracle database
  • List all scheduler jobs from Oracle database
  • List all functions from Oracle database
  • How to list all packages from Oracle database

Post navigation

List all indexes from Oracle database
Display names of all constraints from Oracle database
  • PL/SQL Tutorial
  • PL/SQL Functions
  • PL/SQL Select Query
  • PL/SQL Table Joins
  • PL/SQL Cursors
  • PL/SQL Collections and Records
  • PL/SQL Triggers
  • PL/SQL Views
  • PL/SQL Exception Handling
  • PL/SQL Sequential Control
  • PL/SQL Iterative Control
  • PL/SQL Control Structures
  • PL/SQL Procedure
  • PL/SQL Function
  • PL/SQL Data Types
  • PL/SQL Indexes
  • PL/SQL Constraints
  • PL/SQL %ROWTYPE Attribute
  • PL/SQL %TYPE Attribute
  • PL/SQL Variables
  • PL/SQL Anonymous block
  • PL/SQL Operators
  • PL/SQL Delete
  • PL/SQL Update
  • PL/SQL Insert
  • PL/SQL Select
  • PL/SQL Create Table
  • PL/SQL Alter Table
  • PL/SQL Add Column
  • PL/SQL Modify Column
  • PL/SQL IDENTITY Column
  • PL/SQL Sequence
  • PL/SQL Dynamic SQL
  • PL/SQL CTE
  • PL/SQL REGEXP
  • PL/SQL JSON
  • PL/SQL XML
  • BULK COLLECT
  • FORALL

Learn PL/SQL

  • PL/SQL RAISE_APPLICATION_ERROR
  • PL/SQL SET TRANSACTION
  • PL/SQL Transactions
  • PL/SQL SAVEPOINT
  • PL/SQL ROLLBACK
  • PL/SQL COMMIT
  • PRAGMA AUTONOMOUS_TRANSACTION
  • PRAGMA EXCEPTION_INIT
  • PL/SQL SYS_CONTEXT Function
  • PL/SQL V$SESSION View
  • PL/SQL Session Identifier
  • PL/SQL Tablespaces
  • Tablespace Partition
  • Rebuild partition index Oracle 12c
  • Convert number to fraction
  • Change percentage into decimal
  • Left Outer Join Query
  • Varchar vs Varchar2
Copyright 2013 - 2025 PL/SQL Tutorial | Privacy Policy
↑