Oracle
878 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
2M ago
How to compute how old people are in years from their data of birth to today; check they're at least N years old; find people with birthdays today or in the next N days ..read more
Oracle
2M ago
Congratulations to the winners of the 2023 Oracle Dev Gym Championships! This year the database championships covered features added in Oracle Database 23c, including JSON duality views, the automatic SQL transpiler, and usage domains. As always, the logic competition had a series of puzzles to test players reasoning skills ..read more
Oracle
7M ago
After 14 years and over 700 questions we’re bringing the weekly I Love Logic competition quizzes on Oracle Dev Gym to an end. In it's place we're starting Speed SQL; a game to guess the missing keywords for a series SQL statements within the time limit ..read more
Oracle
8M ago
How to create enumeration domains in Oracle Database 23ai. These enable you to query the list, access the values like constants, and limit values in a table. This helps make your SQL easier to understand and manage while keeping your code simple ..read more
Oracle
1y ago
Announcing the participants in the 2023 Oracle Dev Gym Championships for the Logic and Oracle Database competitions ..read more
Oracle
1y 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
1y 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
1y 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
1y 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
1y 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