Btitle

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

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.