Re: Help with sql plus

hello,

as you used a NUMBER datatype, Oracle does not store non-significative zeros in numbers front as it is usually useless.

If you need this zero, or you must add it manually when displaying it, or you must change your datatype to varchar2. I advice you that 2nd solution as you might also meet international phone numbers starting by "+xy" where xy=country code with a mandatory "+" sign.

regards,
Patrice

"Messiah" <asmithster_at_hotmail.com> a écrit dans le 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

>

>