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

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to create object in Oracle 8?

Re: How to create object in Oracle 8?

From: John Wright <gtaurine_at_hotmail.com>
Date: 2000/06/29
Message-ID: <395B3D7B.E6BB7395@hotmail.com>#1/1

Oh, great! Why the book doesn't tell this? I should put a / at end of each object or whole object cluster?
Where can I find such information?

Thanks!

John

Francis Wong wrote:

> I know it sounds strange but you need to put a / at the end of PL/SQL block.
>
> "John Wright" <gtaurine_at_hotmail.com> wrote in message
> news:395A2B62.4DF8732F_at_hotmail.com...
> > I tried to create the object example in a book, so I typed
> > in SQL*Plus the following:
> > create or replace type ADDRESS_TY as object
> > (Street VARCHAR2(50),
> > City VARCHAR2(25),
> > State CHAR(2),
> > Zip NUMBER);
> >
> > After that, SQL*Plus didn't nothing, but showing the next
> > line number, seemed like it still awaited my input
> >
> > what's wrong with this?
> >
> >
> >
Received on Thu Jun 29 2000 - 00:00:00 CDT

Original text of this message

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