Re: calculate size of a data type used in a create table stmt
From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 15 Sep 2008 06:21:45 -0700
Message-ID: <1221484905.430898@bubbleator.drizzle.com>
Date: Mon, 15 Sep 2008 06:21:45 -0700
Message-ID: <1221484905.430898@bubbleator.drizzle.com>
Srini123 wrote:
> select dbms_metadata.get_ddl('TABLE','EMPLOYEE') from dual
Or query all_tab_cols.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Mon Sep 15 2008 - 08:21:45 CDT