Re: Help with Sql*plus

Since you will be doing no math operations with a phone number, make it a varchar2 type... Just because something is called a number does not mean you have to store it that way...

hth,

"Messiah" <asmithster_at_hotmail.com> 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

-----------== Posted via Newsgroups.Com - Uncensored Usenet News ==----------

   http://www.newsgroups.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Thu May 16 2002 - 16:08:04 CDT