79683

About SQL*Plus

SQL*Plus is a command-line program that you usc to submit SQL and PL/SQL statements to an Oracle database. You can submit statcments intcractively or as SQL*Plus Scripts. SQL*Plus is installcd with the database and is located in your ORACLE_HOME/bin directory.

You can start SQL*Plus from the command linę. or on Microsoft Windows, from the Start menu.

When SQL*Plus loads. it issues the SQL prompt, which looks likc this:

SQL>

At the SQL prompt, you can cnter statements that perform administrative tasks such as shutting down the database or creating a new user, or you can qucry, insert, update, and dclete data.

You can enter a single SQL statement on multiple lines. You rnust end each statement with a semicolon (;). For most statements, you can rerun a statement by entering a slash (/) on a linę by itself.

Wyszukiwarka

Podobne podstrony:
f11 9 Label Tester! HU Hi, this is the versatile JifLabel! It is a multi-line label that was ve
Command-Line Options that Affect Option-File Handling Most MySQL programsthat support option files h
98 99 Next month in Plus much morę Uftii :i<SJrriEK ALL YOU MEED TO *1AKE rwo* Everythi
A WAN is a data Communications network that covers a relatively broad geographic area and that often
mysąid— The MySQL Server mysqld, also known as MySQL Server, is the main program that does most of t
The Opus okl your Opus • • •HAS ARRIYEDWHAT IS YOUR GOAL OR DREAM THAT YOU WANT TO ACCOMPLISH M
How to rotate a PDF file permanently? Ali you need to do is select the PDF document you want to rota
screenshotb opt InputA recording is currently runnlng. What do you want to do? , stop recording add
About SQL Developer Oracle SQL Dcveloper is a graphical version of SQL*Plus that givcs databasc admi
lnvoking MySQL Programs To invoke a MySQL program from the command linę (that is, from your shell or
About SQL To perform many of its opcrations, EM Exprcss submits structurcd query languagc (SQL) stat
About the SQL Tuning Advisor The SQL Tuning Advisor examines a givcn SQL statement or a set of SQL s
RouterlPhysical
ConiniandLine Telnet Client The command linę version of Telnet is a Windows console program. To star
show inter? Switch>enable Switch#show interfaces fastethernetO/2 FastEthernetO/2 is down, linę p
show inter Press RETURN to get started! Switch>enable Switch#show interfaces FastEthernetO/1 is d

więcej podobnych podstron