Re: How to get Info. generated during SQL Parse time

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Thu, 24 Jun 1999 15:04:23 +0200
Message-ID: <7ktaaa$qsc$1@news3.saix.net>

anthonywmhui_at_my-deja.com wrote in message <7ks5pp$pcg$1_at_nnrp1.deja.com>...
>Whenever ORACLE recevied any SQL from clients, ORACLE will PARSE the
>SQL. Parsing includes syntax checking, resolve table name and column
>name and etc. Is there anyway to get the parsing information? I mean,
>the owner of the table, the table a column belongs to and so on.

Are you referring to the database catalogue or dictionary? Oracle has a whole lot of DBA and USER tables that describe the database structures of tables, columns, triggers, sequences etc.

Take a look at the Oracle Server Reference Manual - they describe these tables there. There's simply too many tables to list here. For example, there are 8 different DBA tables that describes COLUMNS alone.

regards,
Billy Received on Thu Jun 24 1999 - 08:04:23 CDT