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

Home -> Community -> Usenet -> c.d.o.server -> Re: reg: sql demo tables oracle 10g

Re: reg: sql demo tables oracle 10g

From: <fitzjarrell_at_cox.net>
Date: Wed, 12 Dec 2007 06:00:41 -0800 (PST)
Message-ID: <51ee06a6-fd1f-4a22-9b0e-2567302a81d6@a35g2000prf.googlegroups.com>


On Dec 12, 5:13 am, gazzag <gar..._at_jamms.org> wrote:
> On 12 Dec, 09:16, disco master <harish.p..._at_gmail.com> wrote:
>
> > hi all
> > I am working on 10g sql prompt
> > I am trying to build demo tables emp,etc.
> > but whn i typed
> > sql>@%ORACLE_HOME%\sqlplus\demo\demobld.sql
>
> > the prompt is exiting ...just vanishing
> > i dont know wht is the problem
> > any solution for this
> > from
> > harish
>
> Where did you find that syntax? Replace "%ORACLE_HOME%" with "?":
>
> SQL>@?\sqlplus\demo\demobld.sql
>
> HTH
>
> -g

On a Windows system that will work. I agree it isn't as elegant or as transportable as using the built-in 'alias' for ORACLE_HOME that you have suggested, but it does the job.

David Fitzjarrell Received on Wed Dec 12 2007 - 08:00:41 CST

Original text of this message

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