SyntaxFix

[oracle] How to retrieve an Oracle directory path?

The ALL_DIRECTORIES data dictionary view will have information about all the directories that you have access to. That includes the operating system path

SELECT owner, directory_name, directory_path
  FROM all_directories

Examples related to oracle

• concat yesterdays date with a specific time • ORA-28001: The password has expired • how to modify the size of a column • How to create a blank/empty column with SELECT query in oracle? • Find the number of employees in each department - SQL Oracle • Query to display all tablespaces in a database and datafiles • When or Why to use a "SET DEFINE OFF" in Oracle Database • How to insert date values into table • error: ORA-65096: invalid common user or role name in oracle • In Oracle SQL: How do you insert the current date + time into a table?

Examples related to directory

• Moving all files from one directory to another using Python • What is the reason for the error message "System cannot find the path specified"? • Get folder name of the file in Python • How to rename a directory/folder on GitHub website? • Change directory in Node.js command prompt • Get the directory from a file path in java (android) • python: get directory two levels up • How to add 'libs' folder in Android Studio? • How to create a directory using Ansible • Troubleshooting misplaced .git directory (nothing to commit)