Get names of all tablespaces from Oracle database
To get names of all tablespaces from Oracle database you can use: USER_TABLESPACES, DBA_TABLESPACES.
Examples
SELECT * FROM USER_TABLESPACES; SELECT * FROM DBA_TABLESPACES;
- 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