RE: SQL PLUS

From: Javier Morales <Javier_at_infojobs.net>
Date: Tue, 21 Nov 2000 16:03:12 +0100
Message-Id: <10687.122615@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C053CD.30213500
Content-Type: text/plain;

charset="iso-8859-9"
Content-Transfer-Encoding: quoted-printable

Here are the most important ones...

=20
=20
=20

save <filename> [replace] --> save the sql command (replace if it = exists)

get <filename>     --> put one sql script into the SQL*Plus buffer
start <filename>     --> launch one sql script
@ <filename>     --> the same as start...
edit <filename>     --> edit in the default editor the last sql command
(buffer)
spool <filename>     --> stores the result into a file or printer...

spool out --> into the printer
spool off --> into the file
exit <filename> --> quit sql*plus

=20
=20
=20
a[ppend]   <text>   =20
c[hange]   <old text>      <new text>   =20

cl[ear] buff[er]
del (delete current line)
del n (delete line n)
del m n (delete line from m to n)
=20

-----Mensaje original-----
De: bunyamin karadeniz [mailto:bunyamink_at_havelsan.com.tr] Enviado el: martes 21 de noviembre de 2000 13:05 Para: Multiple recipients of list ORACLE-L Asunto: SQL PLUS=20

WHICH ONES ARE THE BASIC COMMANDS OF SQL PLUS...=20 =20

Bunyamin K. Karadeniz
Enformasyon Teknolojileri Dir.
Veri Taban=FD Grubu tel : 2873565/1681
HAVELSAN=20

------_=_NextPart_001_01C053CD.30213500
Content-Type: text/html;

charset="iso-8859-9"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-9">

<META content="MSHTML 5.00.2314.1000" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#a6caf0><SPAN class=032340015-21112000>
<DIV><FONT color=#0000ff face=Verdana size=2><SPAN class=032340015-21112000>Here
are the most important ones...</SPAN></FONT></DIV>
<DIV><SPAN class=032340015-21112000></SPAN><FONT color=#0000ff face=Verdana
size=2> </FONT></DIV>
<DIV><SPAN class=032340015-21112000></SPAN><FONT color=#0000ff face=Verdana
size=2> </FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#0000ff face=Verdana size=2><SPAN class=032340015-21112000>save
<filename> [replace]    --> save the sql command (replace if it exists)</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Verdana size=2><SPAN class=032340015-21112000>get
<filename>     --> put one sql script into the SQL*Plus buffer</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Verdana size=2><SPAN
class=032340015-21112000>start <filename>     --> launch one sql script</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Verdana size=2><SPAN class=032340015-21112000>@
<filename>     --> the same as start...</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Verdana size=2><SPAN class=032340015-21112000>edit
<filename>     --> edit in the default editor the last sql command (buffer)</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Verdana size=2><SPAN
class=032340015-21112000>spool <filename>     --> stores the result into a file or printer...</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Verdana size=2><SPAN
class=032340015-21112000>    spool out --> into the printer</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Verdana size=2><SPAN
class=032340015-21112000>    spool off --> into the file</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Verdana size=2><SPAN class=032340015-21112000>exit
<filename>     --> quit sql*plus</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV><FONT size=2><FONT color=#0000ff><FONT face=Verdana>
<DIV>a[ppend]   <text>   
</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT color=#0000ff face=Verdana size=2><SPAN
class=032340015-21112000>c[hange]   <old text>      <new text>   
</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Verdana size=2><SPAN
class=032340015-21112000>cl[ear] buff[er]</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Verdana size=2><SPAN class=032340015-21112000>del
(delete current line)</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Verdana size=2><SPAN class=032340015-21112000>del
n (delete line n)</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Verdana size=2><SPAN class=032340015-21112000>del
m n (delete line from m to n)</SPAN></FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">

  <DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma   size=2>-----Mensaje original-----<BR><B>De:</B> bunyamin karadeniz   [mailto:bunyamink_at_havelsan.com.tr]<BR><B>Enviado el:</B> martes 21 de   noviembre de 2000 13:05<BR><B>Para:</B> Multiple recipients of list   ORACLE-L<BR><B>Asunto:</B> SQL PLUS <BR><BR></DIV></FONT>   <DIV><FONT face=Arial size=2>WHICH ONES  ARE THE  BASIC COMMANDS OF   SQL PLUS... </FONT></DIV>
  <DIV> </DIV>
  <DIV><FONT face=Arial

  size=2>**********************************************<BR>Bunyamin K.

Karadeniz<BR>Enformasyon Teknolojileri Dir.<BR>Veri Tabaný Grubu tel : 2873565/1681<BR>HAVELSAN

  <BR>**********************************************</FONT></DIV></BLOCKQUOTE></BODY></HTML>

Received on Tue Nov 21 2000 - 09:03:12 CST