| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL, SQL PLUS, PL/SQL
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_01C00CD1.F33660D0
Content-Type: text/plain;
charset="iso-8859-1"
Swapna,
You are right about SQL, and PL/SQL
SQL*PLUS is the interface that lets you talk to Oracle databases. It also
has some of its own commands like
SET
EDIT
Line editor for the last SQL command i.e, L, I, etc.
DESCRIBE
HEADINGS
BTITLE
TTITLE
etc.
Regards,
Aleem
-----Original Message-----
From: Swapna_P [mailto:Swapna_P_at_satyam.com]
Sent: 23 August 2000 02:11
To: Multiple recipients of list ORACLE-L
Subject: RE: SQL, SQL PLUS, PL/SQL
i think sql consists of just DML,DCL DDLs
sqlplus supports advanced features like ....cant think of any!
pl/sql supports embedded sql in a procedural language. way......
please expand and add on to the simple idea i hav put fwd...
rgds
Swapna
To: Multiple recipients of list ORACLE-L Subject: SQL, SQL PLUS, PL/SQL
-- Author: Rusnak, George A. II INET: rusnakg_at_SDCL.LEE.ARMY.MIL Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------_=_NextPart_001_01C00CD1.F33660D0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printableReceived on Wed Aug 23 2000 - 02:15:41 CDT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 9">
<meta name=3DOriginator content=3D"Microsoft Word 9">
<link rel=3DFile-List href=3D"cid:filelist.xml_at_01C00CFA.855D1080">
<title>RE: SQL, SQL PLUS, PL/SQL</title>
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings> <o:DoNotRelyOnCSS/> </o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument> <w:Zoom>0</w:Zoom> <w:DocumentKind>DocumentEmail</w:DocumentKind> <w:EnvelopeVis/> </w:WordDocument>
</xml><![endif]-->
<style>
<!--
/* Font Definitions */ @font-face {font-family:"MS Sans Serif"; panose-1:0 0 0 0 0 0 0 0 0 0; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-format:other; mso-font-pitch:variable; mso-font-signature:3 0 0 0 1 0;} @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:553679495 -2147483648 8 0 66047 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig {margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} p {margin-right:0cm; mso-margin-top-alt:auto; mso-margin-bottom-alt:auto; margin-left:0cm; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} span.EmailStyle16 {mso-style-type:personal-reply; mso-ansi-font-size:10.0pt; mso-ascii-font-family:Arial; mso-hansi-font-family:Arial; mso-bidi-font-family:Arial; color:navy;} @page Section1 {size:595.3pt 841.9pt; margin:72.0pt 90.0pt 72.0pt 90.0pt; mso-header-margin:35.4pt; mso-footer-margin:35.4pt; mso-paper-source:0;} div.Section1 {page:Section1;} -->
</style>
</head>
<body lang=3DEN-GB style=3D'tab-interval:36.0pt'>
<div class=3DSection1>
<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D2 =
color=3Dnavy face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>S= wapna,<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D2 =
color=3Dnavy face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><= ![if = !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>=
<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D2 =
color=3Dnavy face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>Y= ou are right about SQL, and PL/SQL<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D2 =
color=3Dnavy face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><= ![if = !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>=
<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D2 =
color=3Dnavy face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>S= QL*PLUS is the interface that lets you talk to Oracle databases. It also has = some of its own commands like<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D2 =
color=3Dnavy face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>S= ET<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D2 =
color=3Dnavy face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>E= DIT<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D2 =
color=3Dnavy face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>L= ine editor for the last SQL command i.e, L, I, = etc.<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D2 =
color=3Dnavy face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>D= ESCRIBE<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D2 =
color=3Dnavy face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>H= EADINGS<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D2 =
color=3Dnavy face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>B= TITLE<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D2 =
color=3Dnavy face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>T= TITLE<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D2 =
color=3Dnavy face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>e= tc.<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D2 =
color=3Dnavy face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'><= ![if = !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>=
<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D2 =
color=3Dnavy face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>R= egards,<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3DEmailStyle16><font size=3D2 =
color=3Dnavy face=3DArial><span style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial'>A= leem<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D2 =
color=3Dblack face=3DTahoma><span = style=3D'font-size:10.0pt;font-family:Tahoma;color:black'>-----Original Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> Swapna_P
[mailto:Swapna_P_at_satyam.com]<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> 23 August 2000 =
02:11<br>
<b><span style=3D'font-weight:bold'>To:</span></b> Multiple recipients =
of list ORACLE-L<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: SQL, SQL =
PLUS, PL/SQL</span></font></p>
<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'><![if = !supportEmptyParas]> <![endif]><o:p></o:p></span></font></p>
<p style=3D'margin-left:36.0pt'><font size=3D3 color=3Dpurple =
face=3DArial><span style=3D'font-size:12.0pt;font-family:Arial;color:purple'>i think sql = consists of just DML,DCL DDLs</span></font><font color=3Dblack><span = style=3D'color:black'> <br>
</span></font><font color=3Dpurple face=3DArial><span =
style=3D'font-family:Arial; color:purple'>sqlplus supports advanced features like ....cant = think of any!</span></font><font color=3Dblack><span style=3D'color:black'> <br>
</span></font><font color=3Dpurple face=3DArial><span =
style=3D'font-family:Arial; color:purple'>pl/sql supports embedded sql in a procedural language. = way......</span></font><font color=3Dblack><span style=3D'color:black'> <br>
</span></font><font color=3Dpurple face=3DArial><span =
style=3D'font-family:Arial; color:purple'>please expand and add on to the simple idea i hav put = fwd...</span></font><font color=3Dblack><span style=3D'color:black'> <br>
</span></font><font color=3Dpurple face=3DArial><span =
style=3D'font-family:Arial; color:purple'>rgds</span></font><font color=3Dblack><span = style=3D'color:black'> <br>
</span></font><font color=3Dpurple face=3DArial><span =
style=3D'font-family:Arial; color:purple'>Swapna</span></font><font color=3Dblack><span = style=3D'color:black'> </span></font><font color=3Dblack><span = style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font>=
</p>
<p style=3D'margin-left:36.0pt'><font size=3D1 color=3Dblack face=3D"MS =
Sans Serif"><span style=3D'font-size:7.5pt;font-family:"MS Sans = Serif";color:black'>----------</span></font><font color=3Dblack><span style=3D'color:black'> <br>
</span></font><b><font size=3D1 color=3Dblack face=3D"MS Sans =
Serif"><span style=3D'font-size:7.5pt;font-family:"MS Sans = Serif";color:black;font-weight: bold'>From:</span></font></b><font color=3Dblack><span = style=3D'color:black'> </span></font><font size=3D1 color=3Dblack face=3D"MS Sans = Serif"><span style=3D'font-size:7.5pt;font-family:"MS Sans = Serif";color:black'>Rusnak, George A. II[SMTP:rusnakg_at_SDCL.LEE.ARMY.MIL]</span></font><font = color=3Dblack><span style=3D'color:black'> <br>
</span></font><b><font size=3D1 color=3Dblack face=3D"MS Sans =
Serif"><span style=3D'font-size:7.5pt;font-family:"MS Sans = Serif";color:black;font-weight: bold'>Reply To:</span></font></b><font color=3Dblack><span = style=3D'color:black'> </span></font><font size=3D1 = color=3Dblack face=3D"MS Sans Serif"><span style=3D'font-size:7.5pt;font-family:"MS = Sans Serif"; color:black'>ORACLE-L_at_fatcity.com</span></font><font = color=3Dblack><span style=3D'color:black'> <br>
</span></font><b><font size=3D1 color=3Dblack face=3D"MS Sans =
Serif"><span style=3D'font-size:7.5pt;font-family:"MS Sans = Serif";color:black;font-weight: bold'>Sent:</span></font></b><font color=3Dblack><span = style=3D'color:black'> </span></font><font size=3D1 color=3Dblack face=3D"MS Sans = Serif"><span style=3D'font-size:7.5pt;font-family:"MS Sans = Serif";color:black'>Tuesday, August 22, 2000 8:31 PM</span></font><font color=3Dblack><span = style=3D'color:black'> <br>
</span></font><b><font size=3D1 color=3Dblack face=3D"MS Sans =
Serif"><span style=3D'font-size:7.5pt;font-family:"MS Sans = Serif";color:black;font-weight: bold'>To:</span></font></b><font color=3Dblack><span = style=3D'color:black'> </span></font><font size=3D1 color=3Dblack = face=3D"MS Sans Serif"><span style=3D'font-size:7.5pt;font-family:"MS Sans = Serif";color:black'>Multiple recipients of list ORACLE-L</span></font><font color=3Dblack><span style=3D'color:black'> <br>
</span></font><b><font size=3D1 color=3Dblack face=3D"MS Sans =
Serif"><span style=3D'font-size:7.5pt;font-family:"MS Sans = Serif";color:black;font-weight: bold'>Subject:</span></font></b><font color=3Dblack><span = style=3D'color:black'> </span></font><font size=3D1 = color=3Dblack face=3D"MS Sans Serif"><span style=3D'font-size:7.5pt;font-family:"MS = Sans Serif"; color:black'>SQL, SQL PLUS, PL/SQL</span></font><font = color=3Dblack><span style=3D'color:black'> </span></font><font color=3Dblack><span = style=3D'color:black; mso-color-alt:windowtext'><o:p></o:p></span></font></p>
<p style=3D'margin-left:36.0pt'><font size=3D2 color=3Dblack =
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial;color:black'>I was recently = asked, what is the difference between SQL, SQL Plus and</span></font><font color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:10.0pt; font-family:Arial;color:black'>PL/SQL. I admit it ... I choked = !!</span></font><font color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:10.0pt; font-family:Arial;color:black'>Where can I find a good definition of = each??</span></font><font color=3Dblack><span style=3D'color:black'> </span></font><font = color=3Dblack><span style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font>=
</p>
<p style=3D'margin-left:36.0pt'><font size=3D2 color=3Dblack =
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial;color:black'>TIA</span></fon= t><font color=3Dblack><span style=3D'color:black'> </span></font><font = color=3Dblack><span style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font>=
</p>
<p style=3D'margin-left:36.0pt'><font size=3D2 color=3Dblack =
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial;color:black'>Al = Rusnak</span></font><font color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:10.0pt; font-family:Arial;color:black'>COM (804) = 734-4937</span></font><font color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:10.0pt; font-family:Arial;color:black'> DSN = 687-4937</span></font><font color=3Dblack><span style=3D'color:black'> </span></font><font = color=3Dblack><span style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font>=
</p>
<p style=3D'margin-left:36.0pt'><font size=3D2 color=3Dblack =
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial;color:black'>-- =
</span></font><font
color=3Dblack><span style=3D'color:black'><br>
</span></font><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:10.0pt; font-family:Arial;color:black'>Author: Rusnak, George A. = II</span></font><font color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:10.0pt; font-family:Arial;color:black'> INET: = rusnakg_at_SDCL.LEE.ARMY.MIL</span></font><font color=3Dblack><span style=3D'color:black'> </span></font><font = color=3Dblack><span style=3D'color:black;mso-color-alt:windowtext'><o:p></o:p></span></font>=
</p>
<p style=3D'margin-left:36.0pt'><font size=3D2 color=3Dblack =
face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial;color:black'>Fat City = Network Services -- (858) 538-5051 FAX: (858) = 538-5051</span></font><font color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:10.0pt; font-family:Arial;color:black'>San Diego, California -- Public Internet = access / Mailing Lists</span></font><font color=3Dblack><span = style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:10.0pt; font-family:Arial;color:black'>-----------------------------------------= ---------------------------</span></font><font color=3Dblack><span style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:10.0pt; font-family:Arial;color:black'>To REMOVE yourself from this mailing = list, send an E-Mail message</span></font><font color=3Dblack><span = style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:10.0pt; font-family:Arial;color:black'>to: ListGuru_at_fatcity.com (note EXACT = spelling of 'ListGuru') and in</span></font><font color=3Dblack><span = style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:10.0pt; font-family:Arial;color:black'>the message BODY, include a line = containing: UNSUB ORACLE-L</span></font><font color=3Dblack><span = style=3D'color:black'> <br>
</span></font><font size=3D2 color=3Dblack face=3DArial><span =
style=3D'font-size:10.0pt; font-family:Arial;color:black'>(or the name of mailing list you want to = be removed from). You may</span></font><font color=3Dblack><span
 |
 |