Show/Hide Columns

Figure 5.9 shows the Show/Hide Columns drop-down menu. This useful feature is for getting the data grid into the order and appearance needed for the final output of the data. Use the View/Edit Query button to show the SQL used to create the current data grid. The Export Dataset button and report button will use the data and columns that appear in the data grid and in the order that they appear in the data grid. This feature is one way to remove unwanted columns from the output, no matter if the output is Export Data, Report Printing, and so on.

Image

FIGURE 5.9 Show/Hide Columns drop-down menu

You can drag and drop the columns by ...

Get Toad for Oracle Unleashed 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.