Search This Blog

Thursday, July 28, 2022

Get Logged in Database/Environment Name in IFS

SELECT Sys_Context('USERENV', 'DB_NAME') FROM DUAL

No comments:

Post a Comment

Read file content from an Oracle Directory in PL/SQL/ in IFS

Read single file DECLARE file_handle_ UTL_FILE.FILE_TYPE; directory_name_ CONSTANT all_directories.directory_name%TYPE := '...

Popular Posts