Query to extract the statement from SQL_ID
With the article “Query to extract the statement from SQL_ID”, you can extract the running statement from SQL_ID
Well, before diving into the article “Query statement from SQL_ID” I would like to introduce this site to you, especially if you’re seeing it for the first time! Scriptdba is the first vertical website on Oracle databases entirely in Italian.
Actually, during 2020, we will launch the English version, but Italian will always be there, regardless.
You got it right, a bilingual website. Why? Because we like to keep things simple, simple for you readers, of course! (a bit less for us).
On scriptdba.com, you’ll find guides, tutorials, and troubleshooting for the most enterprise database out there!
The selected field is SQL_TEXT from the V$SQLAREA table.
Text of the statement from sql_id:
Query to extract the statement from SQL_ID:
set lines 300
pages 999
select sql_text from v$sqlarea where sql_id = '&sql_id';
Stay tuned! Non solo Query statement da SQL_ID
To view my guides on CRS Commands clicca qui!
At this LINK, on the other hand, you’ll find SQL queries.
Stay updated on our activities by joining our community:
Facebook
Youtube
Linkedin
For those who haven’t done so yet, we recommend bookmarking this site, so you’ll always have our solutions to the most common database problems at your fingertips, especially Oracle databases.
0 Comments