Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL 1992 - where (col1, col2) is not null - simplify SQL and easy more to read

Quanwen Zhao2 days ago — edited 2 days ago

I've done several test about “About NOT NULL and NULL predicates in Row Value Expressions” on freesql.com 4 months ago.

As you can see oracle doesn't support the SQL 1992 standard like this: where (col1, col2) is not null …

Then I played with it on https://dbfiddle.uk/ because where there have a lot more other databases to test, PostgreSQL shocked me, which supports the SQL syntax, MySQL is unable to support the syntax as well as Oracle.

The following is my test code.

Oracle - https://dbfiddle.uk/deY2WTxM
MySQL - https://dbfiddle.uk/MBe7vx_7
PostgreSQL - https://dbfiddle.uk/DKChTK4J

Hope to do an enhancement on Oracle & MySQL, heartfelt thanks beforehand!

Best Regards

Quanwen Zhao

Added 2 days ago

#columngroupsfornotnull, #columngroupsfornull, #databaseideas, #notnullideas, #nullideas, #oracleideas, #sqlideas

1 comment

56 views