Re: Help with sql plus

Simple: Do not use NUMBER for telephone numbers, use VARCHAR instead.

Bruno

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

>

>