©Mike Moxcey 1999 next

Insert the data

Now write an insert statement and execute it
@sql_code = <<ENDOFSQL;
insert into oratut.calls
(seq, name, priority, open_date, email,
problem, software, close_date)
values (
oratut.seq_nr.nextval, initcap('$name'), '$priority',
SYSDATE, '$email', '$problem', '$software', $cdate);
ENDOFSQL
&sql($sql_login,@sql_code);


home next