Quoted identifiers appear to be causing more problems and confusion than they are worth; not least the potential creation of "duplicate" column names.

SQL

Oracle

Dev

Quick Tip: Oracle – Commit on Exit

6 Nov 2013 by Sam Varadarajan

Oracle - commit on exit

All-Topics

Oracle

Split Oracle CLOB into Lines - Fast Way

19 Sep 2015 by m_kramar

How to split Oracle CLOB into lines - fast way

SQL

Oracle

Connecting to External Oracle Database with Symfony 4 Framework

12 Jan 2018 by Alvin Bunk

How to connect to external Oracle database with Symfony 4 Framework

Oracle

DBA

Understanding Bytecode and Java Virtual Machines

4 Jul 2020 by CodingKnight

While you don’t need to know about the details of Bytecode and JVMs to qualify as a Java programmer, such knowledge is still very beneficial.

SQL Full Outer Join

29 Dec 2020 by essentialSQL

Understanding SQL full outer join and its reconstruction through other join clauses

SQL

Oracle

SQL-Server

Gotcha #1161: Using Named Parameters with Oracle ODP.NET

8 Jun 2011 by MBigglesworth79

Using Named Parameters with Oracle ODP.NET

.NET

Oracle

QuickTip: Oracle SQLPlus – (IF) Check for parameters to script

23 Dec 2013 by Sam Varadarajan

(IF) Check for parameters to script.

SQL

Oracle

Gotcha: "BEGIN" in Oracle

23 Dec 2013 by Sam Varadarajan

"BEGIN" keyword in Oracle.

SQL

Oracle

The Data Access Layer, Part 2 – Using the Criteria API

5 Sep 2012 by Keyhole Software

With the Criteria API, the effort to support a wide range of query-building operations is within reason.

SQL

Oracle

Dev

What is a Database Trigger?

14 Aug 2019 by essentialSQL

What is a Database Trigger?

Gotcha – Oracle: Null

1 Jan 2014 by Sam Varadarajan

Oracle: Null gotcha

Oracle

Query Plans in SQL

14 Aug 2019 by essentialSQL

Query plans in SQL

What are the Major Parts of a SQL DB?

14 Aug 2019 by essentialSQL

This post discusses the major parts of a SQL database

PostgreSQL 12: New Features and Enhancements

21 Sep 2019 by Shameel

This article walks you through the summary of most important new features. enhancements and breaking changes in PostgreSQL 12.. The post PostgreSQL 12: New Features and Enhancements appeared first on The Developer Space..

Oracle Sequence Promotes Poorly Maintainable Code

4 Apr 2013 by snorkie

Oracle tables have no built-in mechanism for auto numbering. Instead, you must create a separate unique Sequence object and use it each time a record is inserted into the database.

Oracle

SQL-Server

DBA

Oracle: DDL and Forward Slash

26 Dec 2013 by Sam Varadarajan

Oracle: DDL and forward slash

Oracle

Gotcha: Oracle11g Password Case Sensitivity

29 Dec 2013 by Sam Varadarajan

Apparently, passwords are case sensitive in Oracle 11g by default. This can be overridden.

SQL

Oracle

Some of the Many Quirks of Oracle

26 Sep 2014 by Adam Zuckerman

Some of the many quirks of Oracle

Oracle

Dev

What is SQLite3?

14 Aug 2019 by essentialSQL

SQLite3 is a compact free database you can use easily to create and use a database. Learn more about it in this blog post.

SQL Truncate and Delete

14 Aug 2019 by essentialSQL

Truncate and Delete in SQL

SQL

Oracle

SQL-Server

PostgreSQL finally gets Stored Procedures

21 Sep 2019 by Shameel

This article describes the new Stored Procedure feature in PostgreSQL 11.5 and shows you how it differs from Functions.. The post PostgreSQL finally gets Stored Procedures appeared first on The Developer Space..