SQL & PL/SQL

Hi All,

I have to create a temporary table.

I know it can be done by the create global temporary table command and append the statement with ON COMMIT PRESERVE ROWS.

I have got the script for creating the record but I do not know where to place the
ON COMMIT PRESERVE ROWS clause.

It has to be done carefully because the script will be executed at the client site and I can not risk to end uo with creating an otherwise table.

Can anyone help?

Regards,
Amit.