{
  "id": "enwiki-001317110476",
  "slug": "sql-plus",
  "title": "SQL Plus",
  "qid": "",
  "lead": "SQL Plus is the most basic Oracle Database utility, with a basic command-line interface, commonly used by users, administrators, and programmers.",
  "body": "SQL Plus is the most basic Oracle Database utility, with a basic command-line interface, commonly used by users, administrators, and programmers. ==Command types== SQL Plus understands five categories of text: SQL statements PL/SQL blocks SQL Plus internal commands, for example: environment control commands such as SET environment monitoring commands such as SHOW Comments External commands prefixed by the ! char Scripts can include all of these components. An Oracle programmer in the appropriately configured software environment can launch SQL Plus, for example, by entering: $ sqlplus scott/tiger where the Oracle user scott has the password tiger . SQL Plus then presents a prompt with the default form of: SQL> Interactive use can then start by entering a SQL statement (terminated by a semicolon), a PL/SQL block, or another command. For example: SQL> select 'Hello world' as example from dual; EXAMPLE -------------------------------- Hello world ==Usage== Graphical interfaces from Oracle or third parties have diminished the proportion of Oracle database end-users who depend on the SQL Plus environment. Oracle shops typically continue to use SQL Plus scripts for batch updating or simple reports. Oracle Corporation's wrappers/gui-fications/replacements for SQL Plus include: Oracle SQL Plus Worksheet, a component of OEM iSQL Plus or iSQLPlus, a web-based utility SQL Worksheet, a component of Oracle SQL Developer SQL Workshop (part of Oracle Application Express) ==Compatibility== Other vendors have made their software somewhat compatible with SQL Plus script commands or offer a SQL Plus mode of operation. Relevant products include TOAD from Quest Software. ==References== ==External links== SQL Plus documentation Plus FAQ SQL Plus FAQ SQL Plus tutorial",
  "categories": [
    "11060667",
    "22922474",
    "22923122",
    "22959301",
    "23118434",
    "23372576",
    "23372577",
    "23603337",
    "23869629",
    "23888906",
    "24745122",
    "47050202",
    "59128570",
    "90989649"
  ],
  "license": "CC BY-SA 4.0",
  "source_uri": "https://en.wikipedia.org/w/index.php?oldid=1317110476",
  "content_hash": "",
  "created_at": null,
  "updated_at": 1760606170.0,
  "claims": [],
  "contradictions": [],
  "confidence": 0.6,
  "csl": {
    "id": "enwiki-001317110476",
    "type": "webpage",
    "title": "SQL Plus",
    "author": [
      {
        "family": "Anticloud FZ LLE",
        "literal": "Anticloud FZ LLE"
      }
    ],
    "container-title": "encyclopegia.org",
    "publisher": "Anticloud FZ LLE",
    "publisher-place": "Dubai, United Arab Emirates",
    "URL": "https://encyclopegia.org/a/sql-plus",
    "issued": {
      "date-parts": [
        [
          2026,
          11,
          13
        ]
      ]
    },
    "accessed": {
      "date-parts": [
        [
          2026,
          11,
          13
        ]
      ]
    },
    "license": "CC BY-SA 4.0",
    "DOI": "eo1:enwiki-001317110476",
    "isBasedOn": "https://en.wikipedia.org/w/index.php?oldid=1317110476",
    "note": "Immutable snapshot enwiki-001317110476"
  }
}