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)

Oracle Syntax

BTI[TLE] [printspec [text | variable] ...] | [ON | OFF]

Snowflake does not have a direct equivalent to this command.

1. Btitle command

Oracle

Command

IN -> Oracle_01.sql

BTITLE BOLD 'This is the banner title'

SnowSQL (CLI Client)

Command

OUT -> Oracle_01.sql

!!!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

1. SSC-EWI-0073: Pending Functional Equivalence Review.