Beginning Oracle SQL for Oracle Database 18c: From Novice to Professional

© 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 Brumm¹ 

(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.

Figure 4-1

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