Re: reg: sql demo tables oracle 10g

On Dec 12, 9:10 pm, disco master <harish.p..._at_gmail.com> wrote:
> On Dec 12, 6:59 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
>
>
>
>
>
> > 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
>
> Thanks for those suggestions David fitzjarrell
> but i posted the question only after breaking my head several times
> because i was not getting any idea i thought of
> posting it
> from
> Harish- Hide quoted text -
>
> - Show quoted text -

I suppose 'breaking your head' means looking at the output and wondering why. Obviously you haven't looked at the actual CODE in the script or you'd understand much more than you do.

If a simple script can 'break your head several times' I shudder to think what being an Oracle Applications DBA would do to you.

David Fitzjarrell Received on Thu Dec 13 2007 - 07:54:09 CST