Print Thread
Invoking of the Large Data Editor
#35994 10/09/09 07:20 AM
Joined: Apr 2007
Posts: 95
Germany
E
ed10k Offline OP
Member
OP Offline
Member
E
Joined: Apr 2007
Posts: 95
Germany
How can I invoke the Large Data Editor for a VARCHAR2 column with the length < 20 characters?

I would like to see the cell value in HEX!

SQL Query
select cast('A' || chr(9) || 'B' as varchar2(20)) from dual;
This is OK, a mouse click on cell button and then Hex-Tab.


But...
SQL Query
select cast('A' || chr(9) || 'B' as varchar2(19)) from dual;
How can I see the cell value in HEX in this case?

Re: Invoking of the Large Data Editor
ed10k #35999 10/09/09 09:33 AM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
The Large Data Editor button is only displayed for large columns. You would have to use an appropriate cast expression.


Marco Kalter
Allround Automations
Re: Invoking of the Large Data Editor
Marco Kalter #36005 10/09/09 02:14 PM
Joined: Apr 2007
Posts: 95
Germany
E
ed10k Offline OP
Member
OP Offline
Member
E
Joined: Apr 2007
Posts: 95
Germany
Change of the SQL-statement is cumbersome.
And when I waited 2 hours for result of a SQL-statement then I don't like to restart them.

Can you add a menu-item or perhaps a context menu item (rigth mouse click) to invoke the Large Editor?

Re: Invoking of the Large Data Editor
ed10k #36012 10/10/09 11:29 AM
Joined: Aug 1999
Posts: 22,208
Member
Offline
Member
Joined: Aug 1999
Posts: 22,208
I have added this to the list of enhancement requests.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.109s Queries: 14 (0.063s) Memory: 2.5054 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-05-04 07:36:43 UTC
Valid HTML 5 and Valid CSS