Re: Help with sql plus

On Thu, 16 May 2002, asmithster_at_hotmail.com wrote:
>
> I still cannot find a way of inserting a telephone number beginning
> with a zero.

        SQL>create table t1 (fld1 number);

        Table created.

        SQL>insert into t1 values (01);

        1 row created.

        SQL>select * from t1;

              FLD1
        ----------
                 1

Is this what is happening? You are losing the leading 0? Then, you need to make this column a varchar2, cause a phone-number really isn't a number in the datatype sense. It only has the word number in its name.

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

Can you explain what you mean here?

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.