Home » Developer & Programmer » Precompilers, OCI & OCCI » Extracting table/view name(s) from dynamic sql.
Extracting table/view name(s) from dynamic sql. [message #94144] Tue, 30 March 2004 08:10 Go to next message
William
Messages: 17
Registered: September 2000
Junior Member
Has anyone been able to successfully glean the table/view name(s) from a dynamic SQL statement without manually parsing the statement?

I would like to determine if a select statement passed from the command line is for a partitioned table so that I can execute the select by partition in multiple threads.

Seems like is should be an attribute of the statement handle type.
Re: Extracting table/view name(s) from dynamic sql. [message #94147 is a reply to message #94144] Wed, 31 March 2004 09:27 Go to previous message
William
Messages: 17
Registered: September 2000
Junior Member
Sorry, I forgot to mention that this is under the OCI framework.
Previous Topic: Compilation errors
Next Topic: Diff B/W C and Pro*C
Goto Forum:
  


Current Time: Thu Feb 29 22:26:58 CST 2024