Run a Select Statement without a From Clause
Table of Contents

Introduction

You can now run SELECT expression-only queries without a FROM clause.

This is great news for compatibility point of view.

But also from a personal point of view, as I no longer have to listen to Posgress DBAs whining at me about having to specify a from clause :)

Example

This

select sysdate from dual;

can now be coded like this

select sysdate;

Published 22nd December 2023

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License