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

Popular Posts:

Error: Imported Tabl...

What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...

Binary Literals in S...

What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...

Error: Imported Tabl...

What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...

WHILE ... Loops in S...

How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...

"CREATE PROCEDURE" -...

How To Create a Simple Stored Procedure in SQL Server Transact-SQL? If you want to create a simple s...