TestingDocs.com
    Software Testing website
    • Automation
      • Selenium
      • JBehave Framework
    • Tutorials
      • MySQL Tutorials
      • Testlink
      • Maven
      • Git
    • IDEs
      • IntelliJ IDEA
      • Eclipse
    • Flowcharts
      • Flowgorithm
      • Raptor
    • About

    Oracle

    Introduction to Oracle SQL*Plus

    Overview

    In this tutorial, we will learn Oracle SQL*Plus. Oracle SQL*Plus is a database client program with which we can access the backend database. We can execute SQL*PLUS, SQL, PL/SQL commands with the tool.

    It is an interactive query tool that is in-built and installed along with the Oracle database. We will use Windows operating system in this tutorial.

    Start SQL*Plus

    This section shows how to start SQL*Plus tool on Windows.

    We can launch the tool from the Start Menu.

    Start Menu >> Oracle >> SQL Plus

    Alternatively, we can launch the tool from Command prompt. We can find the tool in the bin directory i.e ORACLE_HOME/bin. ORACLE_HOME is a system environment variable that points to the Oracle database install folder.

    Launch Command Prompt.

    Change directory to the ORACLE_HOME/bin directory. We can also append the directory to the PATH environment variable. So that we can type the sqlplus command from anywhere in the directory tree. PATH is a variable with series of directory paths. The Command prompt would search for the command in the PATH.

    Issue the following command:

    \> sqlplus /nolog

     

    sqlplus nolog command

    The /nolog command option starts SQL*Plus tool without connecting to a
    database.

    To know the version of the tool, supply the -v command line switch.

    \> sqlplus -v

    C:\TestingDocs>sqlplus -v
    
    SQL*Plus: Release 19.0.0.0.0 - Production
    Version 19.3.0.0.0

     

    —

    Database Tutorials on this website:

    https://www.testingdocs.com/oracle-database-tutorials-for-beginners/

    More information about Oracle Database:

    https://www.oracle.com/database/

    Related Posts

    Download SQL Developer

    Oracle /

    Download Oracle SQL Developer

    Oracle Databse 19c Download

    Oracle /

    Install Oracle 19c Database On Windows 10

    ORA-01109 Database Not Open

    Oracle /

    Fix ORA-01109: database not open Error

    Oracle SQL Update Statement

    Oracle /

    Oracle SQL Update Statement

    Oracle SQL Insert Statement

    Oracle /

    Oracle SQL INSERT Statement

    ‹ Introduction to SQL(Structured Query Language)› Types of SQL commands

    Recent Posts

    • ChatGPT Plans Free and PlusChatGPT Subscription Plans
    • Stellar Converter for Database ToolStellar Converter for Database
    • Stellar MySQL Log AnalyzerStellar Log Analyzer for MySQL
    • Stellar Repair for MySQLStellar Repair for MySQL
    • ChatGPT IntroductionChatGPT Capabilities
    • How to secure your SQL Database: Tips and Tricks
    • ChatGPT4 Conversational AI FeaturesChatGPT4 Conversational AI Features
    • Trends in Software EngineeringShaping the Future of Development: Exploring Key Trends in Software Engineering
    • Java PerformanceImproving Java Performance with Multithreading
    • QDrant Vector DatabaseOpen-source Vector Databases
    • Difference between PHP and JavaScript?
    • Bing AI Browser Web ContentBing Conversation Styles
    • ChatGPT PreviewChatGPT Introduction
    • Open Source AI Frameworks TensorFlowOpen Source AI Frameworks
    • Artificial Intelligence Tools

    Back to Top

    Links

    • Contact
    • Privacy Policy
    • Cookie Policy

    www.TestingDocs.com