Difference between ttitle and btitle in sqlplus?

Answer 1

1. Both commands are used as header and footer of the page format.

2. Both commands default state is OFF, If we need usage of commands switch to ON state.

3. Ttitle command to format page header and it appears TOP of the each page.

4. Btitle command for footer and it appears at the BOTTOM of the each page.

5. Ttitle automatically put system date and a page number on the report, when ttitle is ON state.

6. we can use a vertical bar ( | ) to split the text of the title across several lines.