SQL Developer
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page SQL Developer
(Created page with "SQL Developer is the new interactiove SQL tool from Oracle. SQL Plus scripts are mainly compatible with it. == Copying SQL Text == The SQL Text column of v$SqlText contains the ...") |
|||
| Line 2: | Line 2: | ||
== Copying SQL Text == | == Copying SQL Text == | ||
| - | + | In SQL Developer when copying certain columns, the text is truncated. For instance, the SQL Text column of v$SqlText contains the ASCII code 0 as the terminator. If the results of the SQL_TEXT column are copied and pasted, then only up to the first terminator will be copied. This can be shown with this SQL: | |
<pre> | <pre> | ||
