SQL Daily @sqldaily

Daily Oracle SQL tips from the Oracle Developer Advocates for SQL blogs.oracle.com/sql Joined January 2015

Tweets

3K
Followers

26K
Following

4
Likes

122

SQL Daily @sqldaily

22 hours ago

Automatically put all unaggregated columns in the SELECT in GROUP BY from Oracle Database 23.9 with GROUP BY ALL Dani Schnider shows how he uses it to find duplicate rows with SELECT t.*, COUNT (*) FROM t GROUP BY ALL HAVING COUNT (*) > 1 danischnider.wordpress.com/2025/08/05/ora…

0 6 22 865 9

SQL Daily @sqldaily

2 days ago

Get values from the previous or next row in #SQL with <fn> ( val ) OVER ( ORDER BY ... ) Where <fn> is either LAG - previous LEAD - next By default these look one row forward/back Use the second parameter to get the value from N rows before/after the current

0 8 24 1K 11

Download Image

SQL Daily @sqldaily

3 days ago

Virtual columns in Oracle Database have long been able to define calculated columns These run the expression on read Store the expression on write from release 23.7 with <col> <data_type> AS ( ... ) MATERIALIZED @GeraldVenzl takes a closer look geraldonit.com/oracle-databas…

0 7 29 1K 9

SQL Daily @sqldaily

4 days ago

Check the security compliance of your Oracle Database with the Database Security Assessment Tool (DBSAT) v4.0 This includes STIG compliance ctandards support User and entitlement assessments Unpatched CVE visibility Pedro Lopes explains blogs.oracle.com/database/post/…

1 5 14 923 7

SQL Daily @sqldaily

5 days ago

The row numbering functions in #SQL are ROW_NUMBER => Consecutive integers starting at one RANK => Rows with the same sort value have the same number; the next row after ties has the same value as ROW_NUMBER DENSE_RANK => Like RANK, but numbers are consecutive after ties

0 11 35 2K 19

Download Image

SQL Daily @sqldaily

a week ago

Practice your Oracle #SQL skills with free quizzes on Oracle Dev Gym SQuizL - complete the statement using the clues provided Speed SQL - race against the clock to guess the missing keywords Weekly DB - a new multiple-choice question every week devgym.oracle.com/pls/apex/f?p=1…

0 4 25 1K 13

Download Image

SQL Daily @sqldaily

a week ago

Limit what can call a PL/SQL unit with accessor lists Only units with a name in the list can call the unit e.g.: PROCEDURE prc ACCESSIBLE BY ( another_proc, some_fn ) Can only be run via units named ANOTHER_PROC or SOME_FN This can give fine-grained access to package units

0 12 42 1K 11

Download Image

SQL Daily @sqldaily

a week ago

Gathering stats can lead to new #SQL plans So if you only gather stats once, plans will stay the same in Oracle Database... right? Wrong! If the data is still changing, the optimizer may think new valid values are out of bounds @vldbb demos blogs.oracle.com/optimizer/post…

0 4 14 806 6

SQL Daily @sqldaily

2 weeks ago

In #database terms A schema is a collection of database objects A user is an account that connects to the database In Oracle Database a user is equivalent to a schema for most practical purposes @petefinnigan explores some of the differences petefinnigan.com/weblog/archive…

0 7 25 1K 9

SQL Daily @sqldaily

2 weeks ago

Use the right data type when defining #database columns, e.g. Numbers => numeric type Datetimes => date/timestamp type Using the wrong data type leads to implicit type conversions which can: Prevent index use => slow SQL Be invalid => runtime errors Choose wisely!

0 5 23 1K 10

Download Video

SQL Daily @sqldaily

2 weeks ago

You can combine the PARTITION BY and ORDER BY clauses in #SQL window functions This splits the rows into groups for each partitioning value Then gets the running total within each group. By default, this is rows with a sort value less than or equal to the group's current row

0 8 35 1K 11

Download Image

SQL Daily @sqldaily

2 weeks ago

The ORDER BY clause of #SQL window functions sorts the rows The function then returns the running total with the window RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW This includes all rows with a sort value less than or equal to the current row's value

0 8 24 1K 8

Download Image

SQL Daily @sqldaily

2 weeks ago

The PARTITION BY clause of #SQL window functions splits the rows into groups It produces one group for each value in the partitioning column(s) The function operates on all the rows in each group and returns the result alongside each row

0 8 34 2K 15

Download Image

SQL Daily @sqldaily

3 weeks ago

The rows returned by the #SQL set operators are UNION All from both tables MINUS/EXCEPT Those in the first table not in the second INTERSECT Rows that are the same in both tables By default, these de-duplicate rows. The ALL clause preserves and accounts for duplicate rows

0 7 40 2K 13

Download Image

SQL Daily @sqldaily

3 weeks ago

The rows returned by the core #SQL joins are INNER Rows with matching values for the join column in both tables OUTER All the rows from the outer table with matching rows from the inner table. A FULL OUTER JOIN preserves both tables CROSS Every row combined with every other

0 5 34 2K 12

Download Image

SQL Daily @sqldaily

3 weeks ago

Database normalization is the process of designing tables to make certain types of data errors impossible This uses normal forms from one to five to remove potential anomalies Learn how to implement them with this video from Decomplexify youtu.be/GFQaEYEc8_8

0 10 38 2K 24

SQL Daily @sqldaily

3 weeks ago

Oracle Database enhanced the set operators in release 21c to include INTERSECT ALL => rows in both tables, including duplicates [ MINUS | EXCEPT ] ALL => rows only in the first table, accounting for duplicates Without the ALL clause, these de-duplicate values

0 12 28 1K 10

Download Image

SQL Daily @sqldaily

3 weeks ago

MCP servers enable you to talk to your database via an LLM Create one for Oracle Database using @oraclesqlcl @krisrice and @thatjeffsmith show you how blogs.oracle.com/database/post/… This can run #SQL on your behalf to answer questions - ensure you restrict what it has access to!

0 11 19 1K 9

SQL Daily @sqldaily

4 weeks ago

Save space in indexes when the leading columns have duplicates with ALTER INDEX ... REBUILD COMPRESS n => deduplicate the first N columns But what is the best value of N? David Kurtz finds it with ANALYZE INDEX … VALIDATE STRUCTURE CASCADE blog.psftdba.com/2025/07/optima…

0 9 36 2K 14

SQL Daily @sqldaily

4 weeks ago

Create many tables in one Oracle DDL statement with CREATE SCHEMA AUTHORIZATION <usr> CREATE TABLE ... CREATE TABLE ... This can also create views and grant access to these objects You must be connected as the <usr> in the AUTHORIZATION clause