Re: As or Is

From: Tom Pall <tom_at_cdproc.com>
Date: Fri, 10 Nov 2000 13:14:05 -0600
Message-Id: <10676.121775@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0058_01C04B18.19E61020 Content-Type: text/plain;

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

Ajay,

In the words of President Bill Clinton, it all depends on what your definition of "is" is.

Seriously, IS and AS are treated the same.

You can be sure there's some ISO standard, and now that I've replied, I'll be immediately corrected by someone citing chapter and verse of the standard.

Both work in Oracle, which is good enough for me.

Original Message -----=20 From: Ajay K=20 To: Multiple recipients of list ORACLE-L=20 Sent: Thursday, November 09, 2000 4:33 PM Subject: As or Is

  Hi Oracle Pundits ,
  a very basic question ,
  what is difference in , create or replace procedure xyz AS ..   and create or replace procedure xyz IS ..   how does AS or IS affects .
  =20
  TIA
  ajay

------=_NextPart_000_0058_01C04B18.19E61020 Content-Type: text/html;

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Ajay,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>In the words of President Bill Clinton, it all =
depends=20
on</FONT></DIV>
<DIV><FONT size=3D2>what your definition of "is" is.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Seriously, IS and AS are treated the =
same.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>You can be sure there's some ISO standard, and=20
now</FONT></DIV>
<DIV><FONT size=3D2>that I've replied, I'll be immediately corrected by=20
someone</FONT></DIV>
<DIV><FONT size=3D2>citing chapter and verse of the =
standard.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Both work in Oracle, which is good enough for =
me.</FONT></DIV>
<BLOCKQUOTE=20

style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">   <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>   <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20
  <A href=3D"mailto:ajay_at_tems.com" title=3Dajay_at_tems.com>Ajay K</A> =
</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A = href=3D"mailto:ORACLE-L_at_fatcity.com"=20
  title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> =
</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Thursday, November 09, = 2000 4:33=20
  PM</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> As or Is</DIV>
  <DIV><BR></DIV>
  <DIV><FONT face=3DArial size=3D2>Hi Oracle Pundits ,</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2>a very basic question ,</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2>what is difference in , create or =

replace=20
  procedure xyz AS ..</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2>and create or replace procedure = xyz IS =20
  ..</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2>how does AS or IS affects=20 .</FONT></DIV>

  <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2>TIA</FONT></DIV>
  <DIV><FONT face=3DArial =

size=3D2>ajay</FONT></DIV></BLOCKQUOTE></BODY></HTML> Received on Fri Nov 10 2000 - 13:14:05 CST