Contents
How do I connect to Oracle Unix shell scripting?
Do the following steps to start SQL*Plus and connect to the default database:
- Open a UNIX terminal.
- At the command-line prompt, enter the SQL*Plus command in the form: $> sqlplus.
- When prompted, enter your Oracle9i username and password. …
- SQL*Plus starts and connects to the default database.
How do I run a shell script in Oracle?
create a shell script owned by the OS user which writes to that common location. create a credential to access that user from inside the database itself. setup and run a scheduler job to execute a shell script as the new OS user. read the output file generated by the shell script from inside the database.
