Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to get the SQL queries based on SQL_ID.

976208Jun 27 2013 — edited Jun 27 2013

Hi Experts,

I want to get the SQL queries based on SQL_ID.

I have tried the following query,but I am not getting full query.

[code]SET linesize 132 pagesize 999

column sql_fulltext format a60 word_wrap

break on sql_text skip 1

SELECT   REPLACE (TRANSLATE (sql_text, '0123456789', '999999999'), '9', ''),sql_id

FROM   dba_hist_sqltext s

WHERE   s.sql_id = '7tvurftg8zryb';[/code]

One of my friend said use grid to get full query text.

Can you please help me how to use grid ,else any other method to get the full query based on SQL_ID.

Please help me.

Thanks in advance.

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 25 2013
Added on Jun 27 2013
8 comments
79,610 views