← Workbench · Notes

Directory Objects in PL/SQL

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;

To view all the tables details, look here.

References

Oracle Doc

Keep reading

See all

Essay

Useful PL/SQL queries

In this post, I’m sharing some handy PL/SQL queries that help with monitoring and maintaining Oracle databases...

Read

Note

NOT IN vs NOT EXISTS in PL/SQL

SELECT * FROM TABLE1 WHERE ID NOT IN ( SELECT ID FROM TABLE2 ) When I ran the above query I know the condition will give me the results, because the data exists …

Read

Note

To extract the value of a tag from an XML-like string in PL/SQL

To extract the value of a tag from the given XML-like string in PL/SQL, you can use the EXTRACTVALUE function or XMLTABLE for XML processing. Example Using …

Read