Re: Sql plus

Messiah wrote:

> 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
> >

VARCHAR2(12) if you store area code, VARCHAR2(8) if you don't.

Think ...

212-555-1212 or 555-1212

Daniel Morgan Received on Thu May 16 2002 - 18:21:24 CDT