Oracle – Capture OS Command Output Using Oracle External Tables

Case for the OS side: Some things are best done on the OS side and there is no question about that. Case for the DB side: Some things are best done on the database side and there is no question about that either. What if? Some things need the output of one in the other … Continue reading Oracle – Capture OS Command Output Using Oracle External Tables

Advertisements

Oracle – Quick Tip – Run OS Commands Within SQL*Plus

There are occasions when you might have the need to run Operating System commands inside SQL*Plus either as part of a script or as an individual command. If you have something simple to run as part of your .sql file that makes your script, just run them as follows: Here is an example that ran … Continue reading Oracle – Quick Tip – Run OS Commands Within SQL*Plus