Goodbye I Love Logic Competition, Hello Speed SQL on Oracle Dev Gym
Oracle | All Things SQL Blog
by
1w 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
Visit website
How to list months of the year or days of the week in Oracle SQL with enumeration domains
Oracle | All Things SQL Blog
by
1M 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
Visit website
Announcing the 2023 Oracle Dev Gym Championships
Oracle | All Things SQL Blog
by
5M ago
Announcing the participants in the 2023 Oracle Dev Gym Championships for the Logic and Oracle Database competitions ..read more
Visit website
IF-THEN logic in SELECT and WHERE with CASE expressions in Oracle SQL
Oracle | All Things SQL Blog
by
6M 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
Visit website
How to compare two tables to get the different rows with SQL
Oracle | All Things SQL Blog
by
8M 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
Visit website
How to calculate the longest and current consecutive streaks with Oracle SQL - #JoelKallmanDay
Oracle | All Things SQL Blog
by
8M 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
Visit website
Free online SQL quizzes on Oracle Dev Gym
Oracle | All Things SQL Blog
by
9M 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
Visit website
How to modify constraints in Oracle Database
Oracle | All Things SQL Blog
by
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
Visit website
Announcing the General Availability of the SQL:2023 Standard
Oracle | All Things SQL Blog
by
1y 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
Visit website
How to write an anonymous PL/SQL function and use it in your SQL statement
Oracle | All Things SQL Blog
by
1y ago
Write anonymous PL/SQL functions as part of your SQL statement, no CREATE FUNCTION privileges required ..read more
Visit website

Follow Oracle | All Things SQL Blog on FeedSpot

Continue with Google
Continue with Apple
OR