Oracle | All Things SQL Blog
865 FOLLOWERS
This is the Oracle SQL blog celebrating the joy and power of Oracle SQL with the Oracle Developer Advocate team. Follow to get daily Oracle SQL tips from the Oracle Developer Advocates for SQL.
Oracle | All Things SQL Blog
3M ago
Announcing the participants in the 2023 Oracle Dev Gym Championships for the Logic and Oracle Database competitions ..read more
Oracle | All Things SQL Blog
4M ago
Learn how to to do if-then logic in SQL using CASE expressions. See examples of using this in the SELECT, WHERE, and JOIN clauses ..read more
Oracle | All Things SQL Blog
6M ago
Ways to compare two tables to see if they store the same data. These methods will return any differences between the data sets using Oracle SQL ..read more
Oracle | All Things SQL Blog
6M ago
An explanation of how to find streaks - a consecutive series of events - using SQL pattern matching in Oracle Database. For example, the number of consecutive days users logged in, their winning streaks or they completed a task ..read more
Oracle | All Things SQL Blog
7M ago
Take free online quizzes on Oracle Dev Gym. These cover database topics: SQL, PL/SQL, & database design along with questions on logical thinking, Java, and more ..read more
Oracle | All Things SQL Blog
10M ago
You can't alter the criteria for a constraint in Oracle Database. To change it you must drop and recreate the constraint. Learn how to do this process online for check constraints, not null, unique constraints, primary keys, and foreign keys ..read more
Oracle | All Things SQL Blog
11M ago
We are pleased to announce the publication of the new SQL:2023 Standard of which many features are supported in Oracle Database 23c Free – Developer Release. Download Oracle Database 23c Free from https://www.oracle.com/database/free/download ..read more
Oracle | All Things SQL Blog
1y ago
Write anonymous PL/SQL functions as part of your SQL statement, no CREATE FUNCTION privileges required ..read more
Oracle | All Things SQL Blog
1y ago
Learn how to use window functions to calculate running totals such as cumulative sums and moving averages with SQL ..read more
Oracle | All Things SQL Blog
1y ago
The winners of the 2022 Oracle Dev Gym Championships ..read more