Chapter 2. Building the Database with the Data Definition Language
SQL*Plus is Oracle’s product for interfacing with the database and is used to create the database objects, grant privileges, populate and modify the tables, and retrieve data from the tables. All of these functions require you to submit commands to the Oracle database manager.
SQL*Plus is the baseline tool for submitting these commands. By baseline, I mean that there are a number of GUI tools available on the market, including some excellent tools from Oracle; however, SQL*Plus is the only tool that always comes with the database. Regardless of your information technology tool architectures, SQL*Plus will be available for you to interface with the Oracle database. SQL*Plus will ...
Get Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts 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.
