File and operating system interaction with SQL and PLSQL

Index

A   B   C   D   E   F   G   H   I   J   K   L   M   N   O   P   Q   R   S   T   U   V   W   X   Y   Z  
A
append_to_file   (FILE_TYPE)
appends to a file

append_to_file   (FILE_TYPE)
appends to a file

append_to_file   (FILE_TYPE)
appends to a file

B
C
clear_environment   (os_command)
removes all environment variables from the "custom environment".

clear_working_dir   (os_command)
clears the working directory for the "exec" calls.

close_stream   (FILE_TYPE)
Closes the "Input Stream".

copy   (FILE_TYPE)
copies the file.

create_dir   (FILE_TYPE)
Creates a new empty directory.

create_file   (FILE_TYPE)
Creates a new empty file.

D
delete_file   (FILE_TYPE)
deletes the file or directory.

delete_recursive   (FILE_TYPE)
deletes the file or directory.

E
exec   (os_command)
executes a shell command

exec   (os_command)
executes a shell command

exec   (os_command)
executes a shell command

exec   (os_command)
executes a shell command

exec   (os_command)
executes a shell command

exec   (os_command)
executes a shell command

exec   (os_command)
executes a shell command

exec   (os_command)
executes a shell command

exec   (os_command)
executes a shell command

exec   (os_command)
executes a shell command

exec   (os_command)
executes a shell command

exec   (os_command)
executes a shell command

exec   (os_command)
executes a shell command

exec   (os_command)
executes a shell command

exec   (os_command)
executes a shell command

EXEC   (file_security)
EXECUTE permission for a filesystem resource (file or folder)

exec_BLOB   (os_command)
executes a shell command

exec_BLOB   (os_command)
executes a shell command

exec_BLOB   (os_command)
executes a shell command

exec_CLOB   (os_command)
executes a shell command

exec_CLOB   (os_command)
executes a shell command

exec_CLOB   (os_command)
executes a shell command

F
file_exists   (FILE_TYPE)
Flag whether this file exists - if a file does not exist, all attributes except this and the full pathname are set to SQL NULL.

file_name   (FILE_TYPE)
Filename

file_path   (FILE_TYPE)
Full absolute path to this file

file_size   (FILE_TYPE)
File size in bytes

G
get_bfile   (FILE_TYPE)
returns a BFILE object, which represents this file handle.

get_content_as_blob   (FILE_TYPE)
Returns the file contents as a BLOB.

get_content_as_clob   (FILE_TYPE)
Returns the file contents as a CLOB.

get_directory   (FILE_TYPE)
Looks up a directory object which represents either, if the file handle is a directory, the handle itself, or the folder in which the file handle resides in.

get_env_var   (os_command)
gets the value of the specified environment variable from the custom environment.

get_file   (FILE_TYPE)
gets a simple file handle.

get_file   (file_pkg)
gets a simple file handle.

get_file   (file_pkg)
gets a simple file handle by directory object and file name.

get_file   (file_pkg)
gets a simple file handle by BFILE.

get_file_list   (file_pkg)
gets all file handles in a directory (directory listing) as a virtual table.

get_file_list   (file_pkg)
gets all file handles in a directory (directory listing) as a virtual table.

get_file_list_p   (file_pkg)
gets all file handles in a directory (directory listing) as a virtual table.

get_file_list_p   (file_pkg)
gets all file handles in a directory (directory listing) as a virtual table.

get_free_space   (FILE_TYPE)
returns the space (in bytes), which is available on the device containing this file handle.

get_fs_encoding   (file_pkg)
gets the current file system encoding

get_parent   (FILE_TYPE)
Returns the parent directory

get_path_separator   (file_pkg)
returns the operating system-specific path separator character; "/" on Unix, "\" on Windows.

get_recursive_file_list   (file_pkg)
gets all file handles in a directory and recursively in all subdirectories (directory listing) as a virtual table.

get_recursive_file_list_p   (file_pkg)
gets all file handles in a directory and recursively in all subdirectories (directory listing) as a virtual table.

get_root_directories   (file_pkg)
gets file handles for all root directories (one for each drive letter on windows platforms) as a virtual table.

get_root_directory   (file_pkg)
returns file handle for the root directory (the first drive letter on windows platforms).

get_script_grant_java_privs   (file_security)
generates a SQL scripts with DBMS_JAVA.GRANT_PERMISSION calls according to the privileges granted on the directory object.

get_shell   (os_command)
returns the operating system call for the current shell.

get_working_dir   (os_command)
gets the current working directory setting; NULL if no working directory was set.

grant_permission   (file_security)
Grants permissions on a file.

grant_stdin_stdout   (file_security)
grants "file descriptor" read and write permissions - these are needed to access STDIN and STDOUT when working with OS_COMMAND.

H
I
is_dir   (FILE_TYPE)
Flag whether this file is a directory ("Y"); "N" otherwise

is_readable   (FILE_TYPE)
Flag whether this file is readable

is_stream_open   (FILE_TYPE)
Checks whether an Input Stream is open on the file.

is_writeable   (FILE_TYPE)
Flag whether this file is writeable

J
K
L
last_modified   (FILE_TYPE)
LastModified date of this file

load_env   (os_command)
copies the default environment (in which the "oracle" process runs) into the custom environment.

load_env   (os_command)
copies the specified environment variable from the default environment (in which the "oracle" process runs) into the custom environment.

M
make_all_dirs   (FILE_TYPE)
Creates a new empty directory similar to MAKE_DIR.

make_dir   (FILE_TYPE)
Creates a new empty directory.

make_file   (FILE_TYPE)
Creates a new empty file.

move   (FILE_TYPE)
performs a "move" / "rename" operation

N
O
open_stream   (FILE_TYPE)
Opens an "Input Stream" on the file.

P
Q
R
READ   (file_security)
READ permission for a filesystem resource (file or folder)

read_byte   (FILE_TYPE)
Reads a single byte from the file input stream.

read_bytes   (FILE_TYPE)
Reads the given amount of bytes from the file input stream.

read_bytes   (FILE_TYPE)
reads the specified amount of bytes at the specified position from the file.

read_string   (FILE_TYPE)
Reads the given amount of characters from the file input stream

read_string   (FILE_TYPE)
reads the specified amount of bytes at the specified position from the file and returns them as a string.

remove_env_var   (os_command)
removes an environment variable from the custom environment.

remove_multiple_separators   (file_pkg)
This function "normalizes" a file path by removing trailing slashes and multiple slashes within the path.

restrict_permission   (file_security)
restricts permissions on a file.

revoke_permission   (file_security)
revokes permissions on a file.

S
set_env_var   (os_command)
sets an environment variable in the custom environment.

set_exec_direct   (os_command)
Execute operating system commands (<b>exec</b> procedures and functions) directly.

set_exec_in_shell   (os_command)
Execute operating system commands (<b>exec</b> procedures and functions) in a shell.

set_fs_encoding   (file_pkg)
sets the encoding to use for file names.

set_Shell   (os_command)
sets the path and "command switch" for the shell to use if <b>set_exec_in_shell</b> was called.

set_working_dir   (os_command)
sets the working directory for the "exec" calls.

skip_bytes   (FILE_TYPE)
Skips the given amount of bytes in the file input stream i.e. moves the "pointer" the given amount of bytes forward.

T
U
use_custom_env   (os_command)
Use "custom" environment variables defined by this package for the "exec" calls.

use_default_env   (os_command)
Use "default" environment variables defined by this package for the "exec" calls.

V
X
Y
Z
File and operating system interaction with SQL and PLSQL