When SQL-Developer gets started, several “.jar”-archives are accessed and some virus scanners will scan the Add the directory where you have installed SQL-Developer from virus scans. Since Oracle 11g, the database offers real-time SQL Monitoring, a great feature for insights of currently. View CLOB data in SQL Developer 710790 Apr 8, 2010 6:00 AM Hi, Can anyone let me know how to view CLOB data in SQL Developer 2.1.
'i have new line in the column. Newlines are characters; if you want to amend text which contains them you need to include them in the search string.
You can do this using the CHR which takes an ASCII value as an argument. The precise codes you need to include vary according to OS.
Because I ran this example on MS Windows I needed to pass both linefeed (ASCII=10) and carriage return (ASCII=13). SQL select.
from t42 2 / TXT - ABCD SQL update t42 set txt=replace(txt,'ABCD' chr(10) chr(13), 'APC woz here') 2 / 1 row updated. SQL select. from t42 2 / TXT - APC woz here SQL Incidentally, if you are storing XML text it might be worthwhile using the XMLType datatype for the column instead of CLOB. It comes with a lot of useful functionality.
Attention, Internet Explorer User Announcement: Oracle Community has discontinued support for Internet Explorer 7 and below. In order to provide the best platform for continued innovation, Oracle Community no longer supports Internet Explorer 7. Oracle Community will not function with this version of Internet Explorer. Please consider upgrading to a more recent version of Internet Explorer, or trying another browser such as Firefox, Safari, or Google Chrome. (Please remember to honor your company's IT policies before installing new software!).