©Mike Moxcey 1999

The sql() source code contd.

$sql_code_begin = "set echo off pages 200 verify off ...etc.";
define sqlplus code to precede passed in sql code
$sql_code_end = "\nset head on lines 80 ...etc. \nquit;\n";
define sqlplus code to follow passed in sql code
@sql_array[0..2] = ($sql_code_begin, @sql_code, $sql_code_end);
concatenate code pieces onto one array variable
@sql_code = @sql_array;
and rename the var


home next