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.

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Compilation errors
Next Topic: Diff B/W C and Pro*C
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 30 22:28:28 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.