In a SQL Script job, you can specify any of the following in the SQL Script field of the Parameters property page:

• Any directives supported by SQL*Plus

• Contents of the SQL script itself

• Fully-qualified SQL script file; for example:

       @/private/oracle/scripts/myscript.sql
  

  Make sure that the script file is installed in the appropriate location on all targets.

• PL/SQL script using syntax supported by SQL*Plus; for example, one of the following:

  EXEC plsql_block;
  

  or

  DECLARE
     local_date DATE;
  BEGIN
     SELECT SYSDATE INTO local_date FROM dual;
  END;
  /
  

  You can use target properties in the SQL Script field, a list of which appears in the Target Properties table. Target properties are case-sensitive. You can enter optional parameters to SQL*Plus in the Parameters field.