BASIC SQL REPORTS AND COMMANDS

BASIC SQL REPORTS AND COMMANDS - BASIC SQL REPORTS AND...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
BASIC SQL REPORTS AND COMMANDS SETTING FEEDBACK SQLPLUS tells you how many rows it found in a table. This is called feedback. You can turn it off or on. The default value is 6 rows. Set feedback off turns it off Set feedback on turns it on Set feedback 25 sets the minimum number of rows to 25 for feedback to work SET and SHOW This is an SQLPLUS command used to tell SQLPLUS how to act. It has a counterpart named SHOW to allow you to see the instructions you've typed, e.g. Show feedback Set numwidth 10 will set the numberwidth for number columns to 10. Columns with more than 10 numbers will not display correctly. REPORT COMMANDS Reports are produced by storing commands to a file that can be executed by using the SQLPLUS START command. You may use whatever editor you prefer to create the report file. REMARK This command can be shortened to REM. SQLPLUS ignores anything on a line that begins with REM to allow you to document your program file. SET HEADSEP This is a Heading Separator command to tell SQLPLUS how you will indicate where you wish to break a page or column heading that is more than one line. The default is the vertical bar (|), but if your keyboard
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
does not have this, use this command to select another character like the exclamation point. Set headsep ! TTITLE and BTITLE The TTITLE stands for top title at the top of each page of a report. Note this example produces a two line split title that is centered on each page of a report. It also default places the day, month, and date the report was run in the upper-left corner of the top title, and the page number in the upper-right corner of the top title. See also the REPHEADER and REPFOOTER commands to control placement of title information for Oracle 7.2 and later. ttitle 'Sales by Month During 2000 | Second Half of the Year' The BTITLE command is for the bottom of each page and centers the output on each page. btitle 'Doug's Report' COLUMN This command allows you to change the heading and format of a column that is in a SELECT statement. This example produces a two- line heading for the column named ITEM, and the following command
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.

Page1 / 7

BASIC SQL REPORTS AND COMMANDS - BASIC SQL REPORTS AND...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online