Re: recreating table structure

From: jAnO! <j.j.groot_at_kpn.com>
Date: 2000/07/06
Message-ID: <8k1jk8$h8l$1@hdxl22.telecom.ptt.nl>#1/1

Chris Dyer <cjd1_at_duke.edu> wrote in message news:Pine.SOL.3.91.1000705112812.3295A-100000_at_teer9.acpub.duke.edu...
> dear group,
>
> I need help! I need to recreate the structure of certain tables in a
> central oracle database in a local oracle database. How can I retrieve
> type information from oracle? I need to ask how wide a varchar2 field is
> or how many digits a number has.
>
> Any help would be hugely appreciated!
>
> Chris

describe table_name;

should help you a bit

greetz jan Received on Thu Jul 06 2000 - 00:00:00 CDT