© Ben Brumm 2019
Ben BrummBeginning Oracle SQL for Oracle Database 18chttps://doi.org/10.1007/978-1-4842-4430-2_12

12. Applying Table and Column Aliases

Ben Brumm1 
(1)
Melbourne, VIC, Australia
 

In all of the chapters so far, you’ve learned how to view data from our database tables. You’ve learned how to choose the columns and rows you want to display using many different methods.

In this final chapter of Part II, we’ll look at two techniques you can use to improve your SQL queries and make them easier to write and easier to understand the results of. The first of these techniques is called a “table alias.”

What is a Table Alias?

A table alias is an alternative name you can apply to your table as part of your SQL query. This alias applies only to your ...

Get Beginning Oracle SQL for Oracle Database 18c: From Novice to Professional now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.