I started a piece of perl to do it ... almost done. I'll post it here.
- sooz
jtesta_at_my-dejanews.com wrote:
>
> I've been toying with the idea, but figured someone out there already did it.
>
> So if anyone has, please speak up, or maybe i'll take up the challenge,
> writing drop column was a good experience, this might be one also.
>
> joe
> http://www.oracle-dba.com
>
> In article <6uejj7$t7m$1_at_garnet.tc.umn.edu>,
> hause011_at_garnet.tc.umn.edu (Steven Hauser) wrote:
> > So nobody in the Unix world using Oracle has ever written a pretty printer
> > for the double quote polluted, token chopped DDL spew that comes from an
> > oracle export utility?
> >
> > Example from the stuff that is PeopleSoft:
> > "CREATE TABLE "PS_CRSE_OFFER" ("CRSE_ID" VARCHAR2(6) NOT NULL, "EFFDT" DATE "
> > ", "CATALOG_NBR" VARCHAR2(10) NOT NULL, "COURSE_APPROVED" VARCHAR2(1) NOT NU"
> > "LL, "CAMPUS" VARCHAR2(5) NOT NULL, "SCHEDULE_PRINT" VARCHAR2(1) NOT NULL, ""
> > "CATALOG_PRINT" VARCHAR2(1) NOT NULL, "SCHED_PRINT_INSTR" VARCHAR2(1) NOT NU"
> > "LL, "ACAD_ORG" VARCHAR2(10) NOT NULL, "ACAD_CAREER" VARCHAR2(4) NOT NULL, ""
> >
> > --
> >
> > ---------------------------------------------------------
> > Steven Hauser, hause011_at_tc.umn.edu
> > Phone: (612)626-7135
> > Fax: (612)625-6853
> > ---------------------------------------------------------
> >
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Sat Sep 26 1998 - 00:04:04 CDT
