FB

Introduction to SQL*Plus

This course will teach you how to get started using SQL*Plus, Oracle's command-line editor for SQL.


You'll learn:

  • What SQL*Plus is and how to access it
  • How to connect to an Oracle database using several different methods
  • How to run SQL commands, format output, run PL/SQL code, export data, and more

Course Length: 55m

Get Access to All Courses Now

Access this course and all other courses (and more) in Database Star Academy instantly:

Course Topics:

Basics

  • What Is SQL*Plus?
  • Open SQL*Plus and Connect to a Database

SQL

  • Creating a Table
  • Copy and Paste Text
  • Insert Data into a Table
  • Selecting Data
  • Describe Statement

Formatting

  • Formatting Columns
  • Formatting Data
  • Command Line Formatting

Advanced

  • Send Query Results to a File
  • Create HTML Reports
  • Run an SQL File
  • Performance in SQLPlus
  • Setting Defaults Using the Login File
  • Run Operating System Commands
  • Run PL/SQL Blocks
  • Conclusion

© 2019 Database Star | Privacy | Terms of Service