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>


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.org
Received on Mon Sep 15 2008 - 08:21:45 CDT

Original text of this message