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
Copyright 2013 - 2023 PL/SQL Tutorial | Privacy Policy
↑