Re: Validating SQL ??

Martin wrote:

> 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)

sorry but i mean that I want to check to see if the syntax is correct. ie

when you do any sql statment oracle will come back and say field name incorrect or somthing like that.

Thanks

Matt Received on Tue Jan 05 1999 - 08:12:09 CST