Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: As or Is

Re: As or Is

From: Jared Still <jkstill_at_bcbso.com>
Date: Fri, 10 Nov 2000 10:58:01 -0800 (PST)
Message-Id: <10676.121806@fatcity.com>


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 Received on Fri Nov 10 2000 - 12:58:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US