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 05:59:18 -0800 (PST)
Message-ID: <6e236997-b173-4a04-89ae-223e7f3569ba@f3g2000hsg.googlegroups.com>


On Dec 12, 3:16 am, 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

It's doing much more than that if you're actually executing the demobld.sql script. I would suggest you do something you havven't yet done -- actually LOOK at the script and see what it does. You will notice an exit at the end of the script, signalling SQL*Plus to, well, exit. And exiting SQL*Plus causes the prompt to 'vanish'. Imagine that.

You have an annoying habit of crying "Wolf!" before you've decided to investigate matters and, as a result, ask such inane questions that it surprises me anyone responds. Have you checked for the existence of these tables BEFORE you try to run this script a dozen more times wondering why the script exits SQL*Plus because you're apparently too lazy to read it?

The problem here lies between your chair and your keyboard. You're the only one who can fix that situation. Please make an effort to do so.

David Fitzjarrell Received on Wed Dec 12 2007 - 07:59:18 CST

Original text of this message

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