COALESCE FUNCTION

SQL SERVER:  COALESCE FUNCTION This SQL Server tutorial explains how to use the  COALESCE function  in SQL Server (Transact-SQL) with s...

Read More

XMLAGG in oracle

Syntax Description of the illustration XMLAgg.gif Purpose XMLAgg  is an aggregate function. It takes a collection of XML fragments ...

Read More

Encrypt Decrypt Data in Oracle 11g

A simple and secured way to encrypt and decrypt data in Oracle 11g with DBMS_OBFUSCATION_TOOLKIT package. DBMS_OBFUSCATION_TOOLKIT enables ...

Read More

Creating Primary Key On A Field Containing Duplicate Values In Oracle

Yes, Oracle can have a primary key table containing duplicate values in particular field, but it doesn't mean that it will allow furth...

Read More

ORACLE/PLSQL: TRIM FUNCTION

ORACLE/PLSQL:  TRIM FUNCTION This Oracle tutorial explains how to use the Oracle/PLSQL  TRIM function  with syntax and examples. DE...

Read More

ORACLE/PLSQL: LTRIM FUNCTION

ORACLE/PLSQL:  LTRIM FUNCTION This Oracle tutorial explains how to use the Oracle/PLSQL  LTRIM function  with syntax and examples. ...

Read More

ORACLE/PLSQL: SUBSTR FUNCTION

ORACLE/PLSQL:  SUBSTR FUNCTION This Oracle tutorial explains how to use the Oracle/PLSQL  SUBSTR function  with syntax and examples. ...

Read More

ORACLE/PLSQL: INSTR FUNCTION

ORACLE/PLSQL:  INSTR FUNCTION This Oracle tutorial explains how to use the Oracle/PLSQL  INSTR function  with syntax and examples. ...

Read More