Oracle - Set Up SQL*Plus Output Format in Oracle

Set Up SQL*Plus Output Format in Oracle

Q

How To Set Up SQL*Plus Output Format in Oracle?

✍: FYIcenter.com

A

If you want to practice SQL statements with SQL*Plus, you need to set up your SQL*Plus output formatting parameter properly. The following SQL*Plus commands shows you some examples:

COLUMN id FORMAT 9999;
COLUMN url FORMAT A24;
COLUMN notes FORMAT A12;
COLUMN counts FORMAT 999999;
SET NULL 'NULL';

⇒Understanding SQL DML Statements for Oracle

⇒⇒Oracle Database Tutorials

2016-10-16, 440👍, 0💬

Popular Posts:

Selecting Some Speci...

How To Select Some Specific Columns from a Table in a Query in SQL Server? If you want explicitly te...

Oracle Database Tuto...

Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...

Transaction Manageme...

Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...

DATEADD() Function U...

How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...

SQL Server Database ...

Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...