Marvin Pascual wrote:
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]]On Behalf Of Lemuel Tomas
> > Sent: Friday, August 09, 2002 1:46 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: [plug] Oracle 9iAS on Linux
> >
> >
> >
> > i assume you want to output a query to a file?
> > \o <file name>
>
> You mean, I'll just type first:
>
> =# \o temp.lst
> =# select * from table_name;
>
> So what's the spool off?
after the select, the file is autoclosed :)
>
> > > - set head off
> >
> > \pset tuples_only
>
> I'll try this one tonight.
>
> > > - set pause on
> >
> > pause is on by default
>
> I don't think so. Ang "set pause on" kasi ay per page ang output eh.
yup, its the default, try it :)
> > > - !<shell_commands>
> >
> > \! <cmd>
>
> You mean, if I want to clear the screen I'll just type:
>
> =# \! clear
>
yup
>
> How about if I want to go to the shell right away? In Oracle's SQL, if I
> type "!", punta agad siya sa shell prompt at pag gusto ko namang bumalik na
> sa SQL, I'll just type "exit".
>
\!
brings you to a shell prompt.
>
> > > - etc.
> >
> > for more help, pls consult \h or \? :)
>
> Okay. =)
>
> ---
> MARVIN T. PASCUAL
> E-Mail: [EMAIL PROTECTED]
> Tel. #: (+63-2) 925-2053/981-7068
> Mobile #: (+62-919) 314-1254
> Linux User No. 247147
rgds,
---lem
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
To subscribe to the Linux Newbies' List: send "subscribe" in the body to
[EMAIL PROTECTED]
