Collections:
Set Up SQL*Plus Output Format in Oracle
How To Set Up SQL*Plus Output Format in Oracle?
✍: FYIcenter.com
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';
2020-01-29, 904👍, 0💬
Popular Posts:
What is Microsoft SQL Server in SQL Server? Microsoft SQL Server is a relational database management...
What Causes Index Fragmentation in SQL Server? Index fragmentation is usually caused by deleting of ...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...