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

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 →

Unique session ID

The UNIQUE_SESSION_ID function returns a character string unique to the session among all sessions currently connected to the database. The return string can be up to 24 bytes in length. Multiple calls to the function from the same session will always return the same string. The program header follows:

Notes UNIQUE_SESSION_ID is functionally identical... Continue Reading →

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

Up ↑