Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Order of fields in a table.

Re: Order of fields in a table.

From: andrewst <member14183_at_dbforums.com>
Date: Fri, 04 Jul 2003 12:42:58 +0000
Message-ID: <3075248.1057322578@dbforums.com>

Originally posted by Ben Brugman
> Order of fields in a table.
>
> Do you insert fields in a table, or do you
> append all new fields to the end.
>
> I prefer to insert the fields, but inserting a field
> can be cumbersome and takes some time
> in a real live database. I am aware that applications
> should not use any order, but there are also humans
> seeing the order of the fields in the database.
> (Checking which fields exist and using general utilities
> etc.).
>
> What is common in your world, adding or inserting ?
>
> ben brugman.

Adding. Inserting isn't worth the effort. You can always provide a view with the columns in the "nice" order.

--
Posted via http://dbforums.com
Received on Fri Jul 04 2003 - 07:42:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US