The user process can be any client-side software that is capable of connecting to an Oracle server process. Throughout this book, two user processes will be used extensively: SQL*Plus and SQL Developer. These are simple processes provided by Oracle for establishing sessions against an Oracle server and issuing ad hoc SQL. A widely used alternative is TOAD (the Tool for Application Developers) from Quest Software, though this is licensed software. End-user applications will need to be written with something more sophisticated than these tools, something capable of managing windows, menus, proper onscreen dialogs, and so on. Such an application could be written with the Oracle Development Tools, with Microsoft Access linked to the Or...
- 1. Relational Database Design Using Oracle
- from OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061), 2nd Edition
- Publisher: Oracle Press
- Released: April 2014