Re: Sql plus

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 Received on Thu May 16 2002 - 14:52:56 CDT