From: "Van Messner" Subject: Re: Confused over AS and IS Date: 2000/05/05 Message-ID: #1/1 References: <4623hskcvl0ku9g8o4bdgdepo473rkb8ro@4ax.com> X-Priority: 3 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 X-Complaints-To: Abuse Role , We Care X-Trace: newshog.newsread.com 957562733 216.179.16.56 (Fri, 05 May 2000 17:38:53 EDT) Organization: BestWeb (bestweb.net) X-MSMail-Priority: Normal NNTP-Posting-Date: Fri, 05 May 2000 17:38:53 EDT Newsgroups: comp.databases.oracle.server Don't worry. Even the President of the United States didn't know what is is. But your case is simpler. You can use is or as, whichever you prefer. Van Ken Sproule wrote in message news:4623hskcvl0ku9g8o4bdgdepo473rkb8ro@4ax.com... > Thanks for you help in advance. > > I am confused as to the significance of the AS and IS in things like : > > Create procedure x() AS - why not IS. i.e. is there some sort of > reasoning I can apply to know when to use AS or IS. > > Create type X AS/IS varray.. > > create or replace trigger before NO AS or IS ? > > Any way, there must be a rhyme or reason for AS and IS --- does any > one know what it is? > > > Best > > Ken Sproule > kenmn@tds.net