1 oracle oinstall 930 3:11:56:37ĪLTER TABLE list_directory_ext LOCATION (fs_list_control_dir:'oraclebase.txt') Īlternatively, from 18c onward we can modify the external table location directly in the SQL.įROM list_directory_ext EXTERNAL MODIFY (LOCATION (fs_list_control_dir:'trace.txt')) We set it back to the default location once we are done.ĪLTER TABLE list_directory_ext LOCATION (fs_list_control_dir:'trace.txt') įILE_NAME FILE_PERMIS FILE_HARDLINKS FILE_OWNER FILE_GROUP FILE_SIZE FILE_DATETIMEĪlert_cdb1.log -rw-r. We can do this by altering the external table LOCATION clause. We can list the files and directories in the trace location by using the "trace.txt" file. The second cat command shows us the contents of the file once it's been written.Ĭat > /u01/fs_list/script/list_directory.sh /u01/fs_list/control/oraclebase.txt /u01/fs_list/control/trace.txt It specifies the date format in a more useful form than the default format. The script lists the files in the directory provided by the external table LOCATION clause. We create the pre-processor script with the following commands. GRANT READ ON DIRECTORY fs_list_control_dir TO testuser1 GRANT READ, EXECUTE ON DIRECTORY fs_list_script_dir TO testuser1 ĬREATE OR REPLACE DIRECTORY fs_list_control_dir AS '/u01/fs_list/control/' GRANT READ, WRITE ON DIRECTORY fs_list_logs_dir TO testuser1 ĬREATE OR REPLACE DIRECTORY fs_list_script_dir AS '/u01/fs_list/script/' We create the Oracle directory objects associated with these physical directories, granting the relevant permissions to our test user.ĬREATE OR REPLACE DIRECTORY fs_list_logs_dir AS '/u01/fs_list/logs/' We create the directories using the following commands. "/u01/fs_list/control" : A directory to hold files to control which directories can be listed."/u01/fs_list/script" : A directory to hold a pre-processor script used to list the files in a directory."/u01/fs_list/logs" : A directory used by the external table to write logs.We create three directories to handle the processing of our directory listing functionality. GRANT CREATE SESSION, CREATE TABLE, CREATE VIEW TO testuser1 We connect to a privileged user, and create a new test user.ĬREATE USER testuser1 IDENTIFIED BY testuser1 QUOTA UNLIMITED ON users
List Files in a Directory From PL/SQL and SQL : Comparison of Methods.
This article is based on this great article by Adrian Billigton, but it's been adjusted to suit my needs.
Java list directory contents how to#
This article shows how to list files in a directory on the database server using an external table. (fileDir.Home » Articles » Misc » Here List Files in a Directory From PL/SQL and SQL : External Table ("Sorting by filename in descending order") Ĭollections.sort(listFile,Collections.reverseOrder()) ("Sorting by filename in ascending order") List listFile = Arrays.asList(fileDir.list()) * how to sort filenames in ascending or descending order
Java list directory contents code#
Java : Source code to sort filenames into descending or descending We used this since we are taking into account the usage of Collections.sort method which takes List as an input parameter. One notable method use on this source code is the usage of Arrays.asList method which convert array into list. This method returns a comparator which sorted the input list into descending order. Instead we will only be using the reverseOrder order method of the Collections class. Since we are only interested in getting the list sorted into ascending or descending order we will not be showing on how to use a custom comparator. However if a comparator is placed as the second argument of the sort method, it will take into precedence that sorting method is relying on the logic of the comparator. Calling the Collections.sort with only with one argument which is list, the list is sorted by default in ascending order. We will be using extensively the Collections class sort method. In this section we will be showing source code on how to list files in ascending or descending order by filename.
0 kommentar(er)
