Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: As or Is
On Sun, 12 Nov 2000, Don Dealy II wrote:
> Kind people,
>
> For those of us without access authority to play boxes, what is the end result of running this "interesting" script?
>
Here's the output:
230 1
222 1
That's all there is.
Jared
>
>
> ---------- Begin Original Message ----------
>
> On 11/10/00 at 2:02 PM Jared Still wrote:
> :>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
> :>
> :>------------------------------------
Received on Mon Nov 13 2000 - 10:05:10 CST
![]() |
![]() |