Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: [SQL] sql script testing ?

Re: [SQL] sql script testing ?

From: News <ecotaj_at_yahoo.com>
Date: Fri, 10 Mar 2000 14:22:39 -0600
Message-ID: <8ablp7$s43$1@galaxy.us.dell.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US