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

4. Selecting Specific Columns

Ben Brumm1 
(1)
Melbourne, VIC, Australia
 
In this chapter, you’ll learn how to show specific columns from your table. It is not always necessary or desirable to return all columns as we did in Chapter 3. As you’ll recall, we executed the following query in that chapter:
SELECT *
FROM employee;
Figure 4-1 shows the results, which are all the columns from the employee table. Fortunately, in this instance there are few columns, so the results are not overwhelming.
../images/471705_1_En_4_Chapter/471705_1_En_4_Fig1_HTML.jpg
Figure 4-1

The results of a query on the employee table ...

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

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.