> -----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? > > - 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. > > - !<shell_commands> > > \! <cmd> You mean, if I want to clear the screen I'll just type: =# \! clear 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". > > - 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
BEGIN:VCARD VERSION:2.1 N:Pascual;Marvin T. FN:Marvin T. Pascual ORG:Bureau of Internal Revenue;Information Systems Development Service TITLE:Information Systems Analyst 1 TEL;WORK;VOICE:9252052 TEL;WORK;VOICE:9817022 TEL;HOME;VOICE:9293952 TEL;PREF:9252052 ADR;WORK:;Systems Maintenance and Support Division;#14 Makadios Street, Sikatuna Village;Quezon City;;1101;Philippines LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Systems Maintenance and Support Division=0D=0A#14 Makadios Street, Sikatuna = Village=0D=0AQuezon City 1101=0D=0APhilippines EMAIL;PREF;INTERNET:[EMAIL PROTECTED] REV:20020423T181951Z END:VCARD
