Re: How to execute a SQL command from the <SRVMGRL> prompt on a UNIX system

For those confused by the various answers to this question the answer below giving the ' ; ' as the answer is the correct one

Regards

--
Kevin A Lewis (BOCM PAULS LTD) - Animal Feed Manufacturer - Ipswich United
Kingdom)
                        <Kevin_A_Lewis_at_Hotmail.com>

The views expressed herein by the author of this document
are not necessarily those of BOCM PAULS Ltd.
Jan <Jan_Gerards_at_hotmail.com> wrote in message
news:82lchr$11f$1_at_tesla.a2000.nl...


> I'm just a newbie.

> but in oracle for windows

> you have to end your command with a semicolon ;


>

> Jan

>

> "Tom Zamani" <tomz_at_redflex.com.au> wrote in message

> news:82kgoq$bdc$1_at_perki.connect.com.au...

> > Have you tried to connect internal.

> > svrmgrl

> > connect internal

> > select sysdate from dual;

> > or something like this

> >

> > Henrik Meldgaard Frisk <hfr_at_bang-olufsen.dk> wrote in message

> > news:82j6m1$806$1_at_news.inet.tele.dk...

> > > Hi All

> > >

> > > I am working on a 'CREATE DATABASE' project on a HP-UX system, and I

> want

> > to

> > > execute some commands from the Server Manager program prompt (svrmgrl)

> > > The SQL command exists of several lines.

> > >

> > > My prompt looks like this:

> > >

> > > SVRMGR> (Here I have my SQL commands

> > >               2> (.........etc.

> > >               3> (.........etc.

> > >               4> (.........end)    AND THEN WHAT !!

> > >

> > > How do I execute my commands that fills 4 lines ? There must be a way

to


> > end

> > > the command and execute it.

> > > A keyboard combination or a sign. I can't find it. I just get a new

line


> > > every time.

> > >

> > > Can enyone help me?


> > >

> > > Henrik

> > > Denmark

> > >

> > >

> >

> >

>

>