Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Set Up SQL*Plus Output Format
How To Set Up SQL*Plus Output Format? - Oracle DBA FAQ - Understanding SQL DML Statements
✍: 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';
2007-04-22, 5550👍, 0💬
Popular Posts:
Can two catch blocks be executed? No, once the proper catch section is executed the control goes fin...
How To Change the Password of Another User Account? - MySQL FAQs - Managing User Accounts and Access...
How To Enter Microseconds in SQL Statements? - MySQL FAQs - Introduction to SQL Date and Time Handli...
Does it matter in what order catch statements for FileNotFoundException and IOExceptipon are written...
What are database triggers? How are the triggers fired? Read this collection of questions and answer...