SQL Developer - Revision history

WikiSysop at 20:05, 18 June 2013

2013-06-18T20:05:01Z

← Older revision		Revision as of 20:05, 18 June 2013
Line 1:		Line 1:
-	SQL Developer is the new interactive SQL tool ~~from~~ Oracle. SQL Plus scripts are mainly compatible with it.	+	SQL Developer is the new interactive SQL GUI tool for the [[Oracle Database]]. [[SQL Plus]] scripts are mainly compatible with it.

	== Copying SQL Text ==		== Copying SQL Text ==

WikiSysop at 04:43, 31 May 2013

2013-05-31T04:43:41Z

← Older revision		Revision as of 04:43, 31 May 2013
Line 1:		Line 1:
-	SQL Developer is the new ~~interactiove~~ SQL tool from Oracle. SQL Plus scripts are mainly compatible with it.	+	SQL Developer is the new interactive SQL tool from Oracle. SQL Plus scripts are mainly compatible with it.

	== Copying SQL Text ==		== Copying SQL Text ==

WikiSysop at 00:17, 18 December 2011

2011-12-18T00:17:29Z

← Older revision		Revision as of 00:17, 18 December 2011
Line 2:		Line 2:

	== Copying SQL Text ==		== Copying SQL Text ==
-	~~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:	+	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>

WikiSysop: 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 ..."

2011-11-21T22:13:37Z

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 ..."

New page

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 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>
select
ADDRESS, HASH_VALUE, SQL_ID, COMMAND_TYPE, PIECE, SQL_TEXT, dump(SQL_TEXT)
from v$sqltext
where
order by hash_value,piece
;
</pre>

The solution is to remove the terminators:

<pre>
select
ADDRESS, HASH_VALUE, SQL_ID, COMMAND_TYPE, PIECE, replace(SQL_TEXT,chr(0),'')
from v$sqltext
where
order by hash_value,piece
;
</pre>