Btitle
Transformation for this command is pending
Description
The
BTITLE
command places and formats a specified title at the bottom of each report page, or lists the current BTITLE definition. (Oracle SQL Plus User's Guide and Reference)
BTI[TLE] [printspec [text | variable] ...] | [ON | OFF]
Snowflake does not have a direct equivalent to this command.
1. Btitle command
Oracle
BTITLE BOLD 'This is the banner title'
SnowSQL (CLI Client)
!!!RESOLVE EWI!!! /*** SSC-EWI-0073 - PENDING FUNCTIONAL EQUIVALENCE REVIEW FOR 'BTITLE STATEMENT' NODE ***/!!!
BTITLE BOLD 'This is the banner title';
Known Issues
1. SnowSQL does not support the display of custom headers and footers in query
Currently, SnowSQL does not support the display of custom headers and footers in query output. However, you can use the following workaround to display header and footer information in your query output:
SELECT column1,
column2
FROM my_table;
SELECT 'This is the banner title' AS BTITLE;
--Another alternative
!print 'This is the banner title'
--To emulate BTITLE COL 5 'This is the banner title'
SELECT CONCAT(SPACE(5), 'This is the banner title');
This alternative solution must consider an additional strategy to disable when in Oracle the BTITLE
command receives the OFF option.
Related EWIs
SSC-EWI-0073: Pending Functional Equivalence Review.
Last updated