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, 420👍, 0💬

Popular Posts:

SQL Server Transact-...

Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...

Using User Defined F...

Where to find answers to frequently asked questions on Using User Defined Functions in SQL Server Tr...

IF ... ELSE Statemen...

How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...

Windows Applications...

How Can Windows Applications Connect to Oracle Servers in Oracle? A Windows application can connect ...

Oracle Database Tuto...

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