Re: [Q]: create table with select statement

Neil_at_bMD.com (Neil Greene) writes:
: 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?
:
Use the COPY command. We use a command similar to the following:

	COPY FROM scott/tiger_at_P:ORASID -
	insert into target_table -
	using select * from source_table;

Hope this helps! Received on Wed Mar 23 1994 - 23:31:57 CET