Oracle development languages

Oracle programmers, coders and developers can get news, tips and advice about the various development languages used with Oracle databases and Oracle applications, including SQL, PL/SQL, stored procedures, Java and J2EE, XML and Web services.

April 05, 2021 05 Apr'21
Supreme Court sides with Google in Oracle API copyright suit

The Supreme Court ruled 6-2 that Java APIs used in Android phones are not subject to American copyright law, ending a longstanding legal battle between Google and Oracle.

Bring yourself up to speed with our introductory content

stored procedure

A stored procedure is a group of statements with a specific name, which are stored inside a database, such as MySQL or Oracle. Continue Reading
PL/SQL (procedural language extension to Structured Query Language)

In Oracle database management, PL/SQL is a procedural language extension to Structured Query Language (SQL). Continue Reading
Open Database Connectivity (ODBC)

Open Database Connectivity (ODBC) is an open standard application programming interface (API) for accessing a database. Continue Reading

Learn to apply best practices and optimize your operations.

A quick glance at the history of C programming languages

Since C hit the scene in 1972, the language has continuously evolved to stay relevant in modern development. We examine C's history and why it's still relevant. Continue Reading
Oracle LEFT JOIN vs. LEFT OUTER JOIN: What's the difference?

Get an explanation of the different types of Oracle joins, including whether there's really a difference between the LEFT JOIN and LEFT OUTER JOIN syntax in PL/SQL. Continue Reading
Three tips for using Oracle insert syntax to insert multiple rows

If you're looking for insert syntax to insert multiple rows in Oracle, read these tips from three of our community members. Continue Reading

We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.

How to perform Oracle Flashback Transaction Queries

Read how Oracle Flashback Transaction Query can eliminate the need to use Log Miner to reconstruct database transactions. Continue Reading
Making Monday the start of the week in Oracle SQL

One reader asks how to set up a report in Oracle SQL so that Monday is the first day of the week. Continue Reading
When to use double quotes in Oracle column to avoid invalid identifier

Are you seeing an invalid identifier? Learn when to use double quotes in Oracle column names to avoid this in this tip from PL/SQL expert Dan Clamage. Continue Reading