Re: sqlloader question

From: Jamie Schrumpf <hatterasNOSPAM_at_hotbot.com>
Date: 9 Dec 1999 21:58:19 GMT
Message-ID: <82p8lr$hv2$4@holly.prod.itd.earthlink.net>

In article <385015A7.6EC33486_at_charlestoncounty.org>, shankeyp_at_charlestoncounty.org says...
>
>I have noticed with Oracle 8.0.XX it is not necessary in the control
>file to specify a object type when naming a column for example:
>
>into table dept
>(
>col1 integer,
>col2 varchar2,
>col3 date
>)
>
>
>into table dept
>(
>col1,
>col2,
>col3
>)
>
>both seem to work.
>My question is why would I want to spesify a object type if I do not
>have to? Is there any reason I want to spesify a object type?
>
>Thanks
>Pete
>
>

Two reasons: portability and documentation. --

---

Jamie Schrumpf Received on Thu Dec 09 1999 - 15:58:19 CST