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

BTITLE BOLD 'This is the banner title'

SnowSQL (CLI Client)

Command

-- ** MSC-WARNING - MSCEWI3... - BTITLE SQL*PLUS COMMAND IS NOT CURRENTLY SUPPORTED BY SNOWFLAKE. **
--BTITLE BOLD 'This is the banner title'

The code for the EWI is not defined yet.

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

No related EWIs.