Directory Objects in plsql

Bino Kochumol Varghese /   2 Mar 2023

This view describes all directories accessible to the user.

SELECT * FROM ALL_DIRECTORIES;

This view describes all directories specified for the entire database.

SELECT * FROM DBA_DIRECTORIES;
References

Oracle Doc

pl-sql

Use the share button below if you liked it.

It makes me smile, when I see it.

Read More

Non-editionable objects

10 Feb 2024

When you are create an object in Oracle Database, default object type will be marked editionable.
Read more

Job commands in Oracle PL/SQL

2 Feb 2024

Here I am listing the commands using for creating, running, and fetching the scheduler jobs in Oracle database for easy reference.
Read more

PL SQL Constraints

27 Aug 2023

To find the constraints in a table SELECT * FROM ALL_CONSTRAINTS WHERE TABLE_NAME='TABLE_NAME' AND OWNER = 'OWNER_NAME'; To find the constarints referring to a table
Read more