When installed, Oracle XE includes both the database instance and the SQL*Plus binary ( sqlplus ). The architecture follows a classic two-tier model:
Controls how many lines are printed before the headers repeat. SET PAGESIZE 50; SPOOL: Saves the output of your commands to a text file. SPOOL my_report.txt; oracle sqlplus express edition
GUI tools often auto-commit changes, masking transaction boundaries. SQL*Plus requires explicit COMMIT or ROLLBACK , teaching ACID compliance. When installed, Oracle XE includes both the database