2011•Unpublished venueRequires access

Appendix B: Using SQL*Plus with Oracle

Henry H. Liu

Abstract

This appendix contains sections titled: Installation SQL*Plus and tnsnames.ora File Basics of SQL*Plus Common SQL*Plus Commands Using SQL*Plus to Execute SQL Statements Using SQL*Plus to Execute PL/SQL Blocks Using SQL*Plus Autotrace to Obtain EXECUTION PLANs and Optimizer Statistics Using SQL*Plus Timing Command Exporting/Importing Oracle Databases with SQL*Plus Creating AWR Reports with SQL*Plus Checking Tablespace Usage with SQL*Plus Creating EM DBConsole with SQL*Plus

About this research paper

What this paper is about

Why it matters

A significance statement is not available in the OpenAlex record.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

Key concepts: PL/SQL, SQL/PSM, SQL injection, Computer science, Stored procedure, Autocommit, SQL, Data Transformation Services