Thumbnail image for Storing XML Data in Oracle: Binary XML, Object-Relational, CLOB

Storing XML Data in Oracle: Binary XML, Object-Relational, CLOB

Binary XML, object-relational, or CLOB? An overview of approaches for storing XML data in Oracle to best fit the nature of the data and its expected use.

Read the Full Article →
SQL XML in Oracle: Generating XML from Relational Data

Generating XML from Relational Data using Oracle SQL/XML

How to generate XML from relational data using a combination of Oracle SQL/XML functions such as XMLELEMENT, XMLATTRIBUTES, XMLFOREST, XMLAGG, XMLSERIALIZE.

Read the Full Article →
Fuzzy Matching with UTL_MATCH

Fuzzy Matching with UTL_MATCH

Oracle supports fuzzy matching with UTL_MATCH functions based on Levenshtein Distance and Jaro-Winkler Distance. A look at UTL_MATCH functions in action.

Read the Full Article →
Thumbnail image for SQL: Compare Two Tables for Differences in Data

SQL: Compare Two Tables for Differences in Data

How to compare two tables that share the same structure, to identify data differences between the two tables: missing rows, extra rows, or mismatch in attribute values.

Read the Full Article →
Convert VARCHAR2 to DATE

DATE Format SQL for Dates Stored as Strings

Convert VARCHAR2 to DATE with appropriate format masks, for comparing two dates stored as strings with different DATE formats in the database.

Read the Full Article →
Thumbnail image for Oracle Partitioning: Range Interval Partitioning

Oracle Partitioning: Range Interval Partitioning

Create Oracle table partitions on-the-fly using range interval partitioning, a beautiful Oracle partitioning feature that obviates the need to pre-create database table partitions.

Read the Full Article →
Thumbnail image for INNER JOIN and OUTER JOIN Explained

INNER JOIN and OUTER JOIN Explained

Overview of INNER JOIN and OUTER JOIN in Oracle, with examples, memory aids and a further drilldown of INNER JOIN and OUTER JOIN types.

Read the Full Article →
Thumbnail image for Grant SELECT on V$ Views

Grant SELECT on V$ Views

Grant SELECT on V$ views to allow non-admin database users to query SYS-owned V$ views (dynamic performance views) such as V$INSTANCE or V$SESSION.

Read the Full Article →
Thumbnail image for How to Find out Your Oracle Database Version

How to Find out Your Oracle Database Version

Three ways to find out your Oracle database version in SQL and PL/SQL: using V$VERSION, V$INSTANCE, or DBMS_DB_VERSION constants.

Read the Full Article →
Thumbnail image for Access Control List (ACL) in Oracle 11G

Access Control List (ACL) in Oracle 11G

Access Control List or ACL is a security mechanism that defines which users or roles can perform which operations on which data. It is an essential setup in Oracle 11G for running network packages such as UTL_HTTP.

Read the Full Article →
Page 4 of 13
1
2
3
4
5
6
7
8
...
13