| 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: As or Is
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_01C04B6E.04A4FB70
Content-Type: text/plain;
charset="iso-8859-1"
Jared!!
How incredibly irresponsible of you to post such a script on the list!
Don't you know there are newbie's here that don't realize that if you
translate
your script into a munitions-creation program and run it, somebody could get
hurt?
Oh My God!
-----Original Message-----
From: Jared Still [mailto:jkstill_at_bcbso.com]
Sent: Friday, November 10, 2000 5:03 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: As or Is
On Thu, 9 Nov 2000, Ajay K wrote:
> 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 .
>
The only difference I am aware of is that each word is spelled differently. This can be proven with the following korn shell script:
#!/usr/bin/ksh
for word in Is as
do
expr='echo $(echo $( echo ${word} | tr "[A-Z]" "[a-z]" | sed -e "s/^.*\([ia]s\).*$/\1/" 2>/dev/null ) | sum)'
eval $expr
done
;)
Jared ( did you say pundit? ) Still
Certified Oracle DBA and Part Time Perl Evangelist ;-)
Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address
jkstill_at_teleport.com - private
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: jkstill_at_bcbso.com 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_01C04B6E.04A4FB70 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12"> <TITLE>RE: As or Is</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>Jared!!</FONT> </P> <P><FONT SIZE=3D2>How incredibly irresponsible of you to post such a = script on the list!</FONT> </P> <P><FONT SIZE=3D2>Don't you know there are newbie's here that don't = realize that if you translate</FONT> <BR><FONT SIZE=3D2>your script into a munitions-creation program and = run it, somebody could get hurt?</FONT> </P> <P><FONT SIZE=3D2>Oh My God!</FONT> </P> <BR> <BR> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Jared Still [<A = HREF=3D"mailto:jkstill_at_bcbso.com">mailto:jkstill_at_bcbso.com</A>]</FONT> <BR><FONT SIZE=3D2>Sent: Friday, November 10, 2000 5:03 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: Re: As or Is</FONT> </P> <BR> <BR> <P><FONT SIZE=3D2>On Thu, 9 Nov 2000, Ajay K wrote:</FONT> </P> <P><FONT SIZE=3D2>> Hi Oracle Pundits ,</FONT> <BR><FONT SIZE=3D2>> a very basic question ,</FONT> <BR><FONT SIZE=3D2>> what is difference in , create or replace = procedure xyz AS ..</FONT> <BR><FONT SIZE=3D2>> and create or replace procedure xyz IS = ..</FONT> <BR><FONT SIZE=3D2>> how does AS or IS affects .</FONT> <BR><FONT SIZE=3D2>> </FONT> </P> <P><FONT SIZE=3D2>The only difference I am aware of is that each word = is spelled</FONT> <BR><FONT SIZE=3D2>differently. This can be proven with the = following korn shell script:</FONT> </P> <BR> <P><FONT SIZE=3D2>------------------------------------</FONT> </P> <P><FONT SIZE=3D2>#!/usr/bin/ksh</FONT> </P> <P><FONT SIZE=3D2>for word in Is as</FONT> <BR><FONT SIZE=3D2>do</FONT> <BR> <FONT = SIZE=3D2>expr=3D'echo $(echo $( echo ${word} | tr = "[A-Z]" "[a-z]" | sed -e = "s/^.*\([ia]s\).*$/\1/" 2>/dev/null ) | sum)'</FONT> <BR> <FONT SIZE=3D2>eval = $expr</FONT> <BR><FONT SIZE=3D2>done</FONT> </P> <P><FONT SIZE=3D2>------------------------------------</FONT> </P> <P><FONT SIZE=3D2>;)</FONT> </P> <BR> <P><FONT SIZE=3D2>Jared ( did you say pundit? ) Still</FONT> <BR><FONT SIZE=3D2>Certified Oracle DBA and Part Time Perl = Evangelist ;-)</FONT> <BR><FONT SIZE=3D2>Regence BlueCross BlueShield of Oregon</FONT> <BR><FONT SIZE=3D2>jkstill_at_bcbso.com - Work - preferred address</FONT> <BR><FONT SIZE=3D2>jkstill_at_teleport.com - private</FONT> </P> <BR> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Jared Still</FONT> <BR><FONT SIZE=3D2> INET: jkstill_at_bcbso.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =Received on Fri Nov 10 2000 - 17:26:45 CST
 |
 |