Log In to the Database

Syntax conventions of this book include all-uppercased words indicate SQL syntax in uppercase, user-supplied information, such as variable names, table names, and so on, is lowercase. SQL formatting will always have SELECT, FROM, WHERE, ORDER BY, GROUP BY on separate lines. SQL syntax enclosed with [ ] is optional. Any uppercase SQL syntax that is underlined is the default behavior if no option is specified. User supplied information (such as names) will be in lowercase.

SQL*Plus is the standard SQL character-mode interface to Oracle9i. SQL*Plus is used for ad-hoc queries, character-mode/script reporting, and character-mode/script database administration.

There are several ways to invoke SQL*Plus. The first method discussed ...

Get Oracle9i™ Development by Example now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.