6/25/2023 0 Comments Command tab plus alternative![]() To alter the format, you can DEFINE _page with a new formatting string as follows: SET ESCAPE / SQL> DEFINE _page = 'Page /&P2' The default value of _page is the formatting string "page &P4". You can control the formatting of page numbers in the old forms of TTITLE and BTITLE by defining a variable named "_page". You can change the line separator character with SET HEADSEP. A separator character (|) begins a new line two line separator characters in a row (||) insert a blank line. SQL*Plus centers text based on the size of a line as determined by SET LINESIZE. The text you enter defines the title TTITLE displays. The old form defines the top title as a line with the date left-aligned and the page number right-aligned, followed by a line with centered text and then a blank line. The old form of TTITLE offers formatting features more limited than those of the new form, but provides compatibility with UFI (a predecessor of SQL*Plus). Places and formats a title at the top of each report page or lists the current TTITLE definition.ĭisplays a title at the top of each report page. Sets the text to be printed between SELECTed columns.Ĭontrols whether SQL*Plus truncates a SELECTed row if it is too long for the current line width. Sets the character used to prefix substitution variables. Use the SQL*Plus SAVE, GET, and START commands to create and use external files. ![]() Įnables the editing of the SQL*Plus command buffer, or the contents of a saved file. Sets the number of blank lines to be printed from the top of each page to the top title. Places a comment which SQL*Plus does not interpret as a command. Resets column display attributes to default values. Places and formats a title at the bottom of each report page or lists the current BTITLE definition.
0 Comments
Leave a Reply. |