Re: Table constraints

From: Jackie Pepper <jpepper_at_keyworth.u-net.com>
Date: 1997/05/30
Message-ID: <01bc6d52$b7956b60$438577c2@keyworth.u-net.com>#1/1

Roger,

Why not use the data dictionary to generate your create statement automatically..

You can get the definition of the tables from ALL_TAB_COLUMNS along with the column definitions. Then use the DBMS_SQL package to create the temporary table on the fly.

WRT the NULL problem, why not use the SQL*Loader in line logic to replace NULL with another value that you can subsequently change or remove..

Regards

Jason Received on Fri May 30 1997 - 00:00:00 CDT