Explore >> Select a destination
|
You are here 
|
oracletoday.blogspot.com | ||
| | | | |
blog.tanelpoder.com
|
|
| | | | | Some years ago I wrote about how sqlplus allows you to run sqlplus scripts directly from HTTP and FTP locations instead of the local filesystem. By the way, I didn't even notice - my blog is over 5 years old already! :) I a recent email thread Marco Gralike just showed the simplest way I to open a HTTP URL and download + list its contents in a CLOB datatype. It's the HTTPURITYPE and its getCLOB (and getBLOB) methods. - Linux, Oracle, SQL performance tuning and troubleshooting - consulting & training. | |
| | | | |
connor-mcdonald.com
|
|
| | | | | When I'm troubleshooting, a common workflow for me isextract a problematic SQL statement from V$SQL or V$SQLSTATS or an AWR report.drop the SQL text into SQL Developer or VS Code so that I can format it into a more readable format.That was starting to frustrate me so I thought: "Why not have a SQL Formatter... | |
| | | | |
carlos-sierra.net
|
|
| | | | | SQLTXPLAIN includes into the sqlt/utl sub-directory a script named coe_xfr_sql_profile.sql. This script inputs a SQL_ID, then it asks to choose from a list of known Plan Hash Values (PHV), and after a few seconds it outputs another script that contains the Outline of the PHV together with the SQL Text for the given SQL_ID. These... | |
| | | | |
chrisaldrich.wordpress.com
|
|
| | | This post was originally published on Chris Aldrich | ||
