Assigning Field Size

From: Super Grover <sprgrvr_at_worldaccess.REMOVE.nl>
Date: Thu, 11 Jun 1998 20:23:47 +0100
Message-ID: <1dah6ov.3wnbgpugtkwqN@dc2-modem1545.dial.xs4all.nl>

Hello,

Usually I create tables in Oracle Navigator but recently I created a table with SQL*Plus. So I didn't (have to) specify field sizes and or precisions. Neither the type of data (number, char etc.). Since the field was a result of a multplication I assume that Oracle automatically assigned NUMBER.

But I wonder what the effect is of not assigning a fixed field size/precision to a field. Will it affect performance or something? Does anyone know?

Thanx,
James Received on Thu Jun 11 1998 - 14:23:47 CDT