Re: Help with sql plus

Then what is it, what should i replace number with in the following table for school_telno:

 Name                                      Null?    Type
 ----------------------------------------- -------- ------------------------
----
 SCHOOL_NO                                          NUMBER(2)
 SCHOOL_NAME                                    VARCHAR(25)
 SCHOOL_ADD                                         VARCHAR(30)
 SCHOOL_TELNO                                       NUMBER(11)

Thanks

M

"Steve" <someone_at_remove.trolltec.co.uk> wrote in message news:3ce4160e$1_3_at_mk-nntp-1.news.uk.worldonline.com...
>
> "Messiah" <asmithster_at_hotmail.com> wrote in message
> news:iUSE8.4102$Ag2.136173_at_newsfep1-win.server.ntli.net...
> >
> > Hi,
> >
> > I am new to oracle and am only using it for a uni project, having got a
> > stack of books beside me I still cannot find a way of inserting a
> telephone
> > number beginning with a zero.
> > I have used a 'number' for the variable but each time I enter a number
> which
> > starts with zero it only displays the next number.
>
> A telephone number isn't a number.
>
> Steve
>
>
Received on Thu May 16 2002 - 17:52:14 CDT