Column formating in tables

From: <gordon_at_telebusiness.co.nz>
Date: Mon, 10 Jan 2000 20:14:55 GMT
Message-ID: <85dejg$m4b$1@nnrp1.deja.com>

What is the best way to format column output for numbers? At the moment I am using a to_char(fieldname,'999990.000') in SQL statements. Is there any way I can include this in the create table command instead so I only have to do this once? I have had a look in the documentation but all I seem to be able to find out about is constraints.

Cheers
Gordon

--
Gordy
ICQ 3290116
http://www.geocities.com/Area51/Cavern/4253

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jan 10 2000 - 14:14:55 CST