sql – Search for a particular string in Oracle clob column

Examples

Source: http://sqlfiddle.com/#!4/1878f6/164

SQL VARCHAR2 Functions and Operators on LOBs http://docs.oracle.com/cd/B19306_01/appdev.102/b14249/adlob_sql_semantics.htm#g1016221 Source: sql - Search for a particular string in Oracle clob column - Stack Overflow Convert string to CLOB

SQL corner: remove duplicated number

Last time I have problem with duplicated number. Our callback interfaces write to us many error_number. So first i have to find where is and how many this number are. Function to remove double number: SQL Fiddle http://sqlfiddle.com/#!4/75b32/1/1 http://rextester.com/l/oracle_online_compiler http://dbfiddle.uk/ https://livesql.oracle.com/apex/livesql/file/index.html

subprogram inlining in 11g

Very usefully website 🙂 for PLSQL developers! subprogram inlining in 11gThe release of Oracle 10g brought with it the first optimising compiler for PL/SQL. As discussed in this oracle-developer.net article, Oracle added two levels of optimisation to provide some impressive performance gains without changing a line of code.Oracle 11g has taken compiler optimisation further, in... Continue Reading →

Best Sublime Text 3 Themes

Boxy theme Nice themes for my liked editor it is: https://packagecontrol.io/search/boxy Source: Best Sublime Text 3 Themes of 2015 and 2016 ― Scotch Sublime Text 3 Keyboard Shortcuts Source: https://www.cheatography.com/tdeyle/cheat-sheets/sublime-text-3/ General Command Pallete CTRL + SHIFT + P Show­/Hide Console CTRL + ` Show­/Hide Sidebar CTRL + K, B Redo Last Keyboard Shortcut CTRL +... Continue Reading →

f.lux: software to make your life better

It is very usefully application for all ppl witch long working with computer... f.lux automatically warms up your computer’s screen colors at sunset and returns them to normal at sunrise. This new version shapes your light based on your own schedule and internal clock.             Source: f.lux: software to make... Continue Reading →

Proudly powered by WordPress | Theme: Baskerville 2 by Anders Noren.

Up ↑