Re: Sql plus

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

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3CE40E14.B5D09ABA_at_exesolutions.com...
> Messiah wrote:
>
> > 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.
> > Also which is the best way of inserting data into a table, I find
entering
> > one row at a time very long winded, is there a quicker way to enter a
few
> > rows at a time.
> >
> > Thanks for any help
> >
> > M
> >
> > --
> >
> > --
> >
>
> --------------------------------------------------------------------------

--


> > -----------

> > This email and all attachments have been scanned

> > with Norton Anti Virus, Total protection for Pc and Mac

> >

> > www.symantec.com

>

> Phone numbers are not numbers ... they are strings.

>

> Same thing goes for zip codes.

>

> Change the fields and change the variables to match. Though it is better

to


> define your variables as table_name.field_name%TYPE

>

> Daniel Morgan

>