Search notes:

SQLPATH - run_files_in_curdir.sql

run_files_in_curdir.sql is a script that »executes« sql files matching a file-pattern (xyz*.sql) within SQL*Plus.
sql> @run_files_in_curdir xyz*.sql
--
--   Windows only.
--
--   Executes («run») the files in the current directory
--
define file_pattern=&1
$echo -- Created by %SQLPATH%\run_files_in_curdir.sql > %temp%\run_files_in_curdir_.sql
$@for /f "usebackq" %a in (`dir /b &file_pattern`) do @echo @ %a >> %temp%\run_files_in_curdir_.sql
prompt %temp%\run_files_in_curdir_.sql created, running it...
@%TEMP%/run_files_in_curdir_.sql
Github repository Oracle-SQLPATH, path: /run_files_in_curdir.sql

See also

Oracle: files for ORACLE_PATH / SQLPATH

Index