Re: [Q]: create table with select statement

From: Neil Greene <Neil_at_bMD.com>
Date: Wed, 23 Mar 1994 07:03:12 GMT
Message-ID: <1994Mar23.070312.28061_at_bMD.com>

In article <1994Mar23.065533.27595_at_bMD.com> Neil Greene <Neil_at_bMD.com> writes:
> I was just wondering if creating a table with the select * option works
> properly if the table contains fields of type long?

Never mind, it doesn't work. Anyone have any suggestions to properly copy long datatypes between tables. I have a Pro*C solution I guess I should dig up. I could also spool the data to a file and then load via sql*loader. But, there are limitations to sql*plus. Any other suggestions?

Sincerely,

Neil Greene

---

benchMark Developments, Inc.
120 East Main Street, Suite 1101
Lexington, KY 40507
neil_at_bMD.com

-- 
Sincerely,

Neil Greene

Received on Wed Mar 23 1994 - 08:03:12 CET