SQL AS: Usage, Examples, and How it Can Benefit You Best

What is the AS statement in SQL? The AS keyword in SQL is used to create a temporary alias for a table or column. This alias can be used instead of the name in the SELECT statement.

The SQL language has three different ways of naming things: identifiers, table aliases, and column aliases. These are just nicknames we give things so they’re easier to talk about and work with. A good example of this would be your email address. It may be anything you want it to be. However, many people choose to use their first initial and last name instead of full names, so that they’re easier to find.

CodingSight - SQL AS Statement
Read More

Oracle Live SQL: Pros and Cons, and What You Miss Out if You Don’t Try It

Oracle Live SQL is a new feature in Oracle Database 12c that allows the developers to easily create and run SQL scripts against Oracle databases. It is suitable for quick code demos, debugging, and troubleshooting. In general, it is an easier way for those who are teaching or demonstrating SQL, PL/SQL, or another function to use Oracle.

The good thing about Oracle Live SQL is that it works with any database on the platform (not just Oracle), so the choice is up to you.

CodingSight - Oracle Live SQL
Read More