Re: Validating SQL ??

Matthew Green <matthewgreen_at_powersoft-services.co.uk> schrijfbewerkingen: >
> Is there a command which will let me validate SQL statements before
> applying them e.g..
>
>
> update contacts
> set name = 'ABC'
>
>
> so I want to check if the syntax is right before executing.
>
>
> If you can shed any light
>
>
> Thanks
>
> Matt
 

If you mean you want to check if the data updated is correct, you can use rollback and commit;

When you want to undo rollback, when you want to apply commit; Make sure autocommit is set to off in your sqlplus session. (default it is I think) Received on Tue Jan 05 1999 - 07:54:32 CST