How to run a Windows or UNIX command using PLSQL code

This can be done using HOST command provided by the PLSQL code:

Example for the same:

DECLARE

v_win_command VARCHAR2 (100);

BEGIN

v_win_command:= 'md c:\temp\myreports';

-- (MD IS THE COMMAND USED IN WINDOWS TO CREATE DIRECTORY/FOLDER)

HOST (v_win_command, no_screen);

END;