WikiSysop at 20:10, 6 February 2017

2017-02-06T20:10:26Z

WikiSysop: 1 revision imported

2016-03-25T08:51:08Z

1 revision imported

WikiSysop at 20:05, 18 June 2013

2013-06-18T20:05:01Z

New page

SQL Developer is the new interactive SQL GUI tool for the [[Oracle Database]]. [[SQL Plus]] scripts are mainly compatible with it.

== 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>
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>

← Older revision		Revision as of 20:10, 6 February 2017
Line 23:		Line 23:
	;		;
	</pre>		</pre>
		+	==Further Reading==
		+	[[SQL Plus]]

← Older revision	Revision as of 08:51, 25 March 2016
(No difference)

SQL Developer - Revision history

WikiSysop at 20:10, 6 February 2017

WikiSysop: 1 revision imported

WikiSysop at 20:05, 18 June 2013