Parsing SQL Statement

From: Deepak Sharma <sharmakdeep_oracle_at_yahoo.com>
Date: Wed, 21 Mar 2007 07:48:38 -0700 (PDT)
Message-ID: <20070321144838.59273.qmail@web52801.mail.re2.yahoo.com>

Is there an easy way to extract the different parts of an SQL statement (SELECT, FROM, WHERE), in order to determine the columns being used, tables being accessed and columns being used in the where clause?

For simple SQL that has only one of the above clauses, may be simple (using substr, instr etc.), but it gets complicated with inline views, sub-queries etc.

Would "Oracle Text" be of any significance here in order to do the parsing?

The idea is to use database auditing (using db,extended ) that would capture the SQL statement, but we could then parse the SQLs to see the column-access usage, table accessed in the SQL and the colums used in the where condition (this may also be present already in sys.column_usage, but I'm not sure).

Thanks,
Deepak  

---

8:00? 8:25? 8:40? Find a flick in no time with the Yahoo! Search movie showtime shortcut. http://tools.search.yahoo.com/shortcuts/#news

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 21 2007 - 09:48:38 CDT