Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: [SQL] sql script testing ?
Answer to second question (dont know the first one): "show user"
or "select * from v$instance;"
Alain Kreienbuhl wrote in message <38C92587.BE35671_at_fisystem.fr>...
>Hello,
>
>Is there a way to test a SQL (DDL) script without it accually doing
>something. Typically after doing some minor changes, I'd like to check
>that the script still holds together w/o having to run the whole script
>again.
>
>Thanks.
>
>(Also in a sql*plus session is there a way to see where I'm currently
>connected).
>
>Thanks again.
>
>Alain.
>
Received on Fri Mar 10 2000 - 14:22:39 CST
![]() |
![]() |