Redgate Flyway, Oracle, and the Case of the Lowercase Schema
If you’ve spent any time working with Oracle databases, you’ve probably internalized a few expectations so deeply that you don’t even think about them anymore. One of the biggest is this: Database users, tables, views, and metadata are in UPPERCASE. So, when you query the database directly, no matter if using SQL*Plus, SQLcl,SQL Developer, or any other tool, you’re going to format your query in a common way.