Accessing and Using SQL*Plus Interface

The Oracle Database 10g product provides you with one command-line interface to access, insert, update, or delete data, and create, alter, or drop structures in database instances. The interface enables you to interact with the database by using Structured Query Language (SQL). If you are unfamiliar with the concepts of SQL, please check Appendix D, “SQL Primer,” before continuing with this segment.

Oracle SQL*Plus is an interactive environment where you can enter SQL statements and process them one by one, or you can run scripts as batch submissions. Scripts are small SQL programs or collections of programs found in a single file. The SQL*Plus environment is also a programming shell environment and supports ...

Get Oracle Database Ajax & PHP Web Application Development 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.