This content has been marked as final. Show 2 replies
No. The SELECT statement is not associated with the table in the data dictionary.1 person found this helpful
If the statement was executed recently, you may find the entire CREATE TABLE in the V$SQL view. Or, if you have licensed the AWR, you may find it in the DBA_HIST_SQLTEXT view. But there is no guarantee that the query will be in either view.
Edited by: Justin Cave on Jul 29, 2012 3:46 AM
Additionally, this question doesn't appear to relate to the Oracle Call Interface so it should probably have been asked in a different forum. The General Questions forum or the SQL and PL/SQL forum would have been more appropriate.
I wanted to post this in SQL section. I did not observe this until you mentioned that.