Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: How to create object in Oracle 8?
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
![]() |
![]() |