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 →

PLSQL corner

PLSQL loop inexed by letters

But this is not portable across character sets. I think a better solution is to declare up front your index variables like this:

That way if you change character sets (e.g. to utf8) you are not reliant on a collating sequence that doesn't match your char set.

RegEx never endig story….

It is example of use RegEx to prepare SQL data for SELECT/UPDATE operation. /^.*/gm ^ asserts position at start of a line .* matches any character (except for line terminators) * Quantifier — Matches between zero and unlimited times, as many times as possible, giving back as needed (greedy) Global pattern flags g modifier: global.... Continue Reading →

SQL corner: 7 kind of SQL Joins. Including : INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN

Infographic of the 7 kind of SQL Joins. Including : INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, with or without the intersect. Very useful for web developer. Source : http://sql.sh #SQL #JOIN Source: Pinterest http://sql.sh/2401-sql-join-infographie Other sources about JOIN https://docs.oracle.com/cd/B28359_01/server.111/b28286/queries006.htm https://www.techonthenet.com/oracle/joins.php - This Oracle tutorial explains how to use JOINS (inner and outer) in... Continue Reading →

Narzędzia to projektowania baz danych

GNU-GPL OpenSystemArchitect http://www.codebydesign.com/ Power*Architect http://code.google.com/p/power-architect/ Druid http://druid.sourceforge.net/ ERW http://erw.dsi.unimi.it/ Dia http://live.gnome.org/Dia XML to DDL (python scripts) http://xml2ddl.berlios.de/ Graphiz - I believe I've read of people using it to reverse engineer from DDL http://graphviz.org/ Multiple versions/licenses (each has a "free" and a "not-free" version) DBVisualizer Toad http://www.toadsoft.com/ Not-free Microsoft Visio - (If you already have it,... Continue Reading →

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

Up ↑