Re: Need to recreate Schema from PL/SQL files

In article <8tcq9b$ad0$1_at_nnrp1.deja.com>,   furland_at_my-deja.com wrote:
> Hello,
>
> I have a few hundred PL/SQL files, but no accompanying database. I've
> been tasked with determining which fields in which tables are used by
> these files.
>
> Is there a tool that will do this for me, or must I:
> a) manually weed thru 100,000 lines of SQL statements, or,
> b) write a parser
>
> Furthermore, would such a tool be useful to other people if I do have
> to write it?
>
> TIA,
> -Dan
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

c) get Personal Oracle. You can download it for free. Run the scripts and use the dictionary (specifically user_tab_columns) to get that cross-reference.
The other options are just to make sure you are employed and don't become a criminal.

Regards,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.