SQL*Plus User's consultant and Reference is meant for company and technical clients and process directors who are looking to use SQL*Plus within the home windows 2000, home windows NT or home windows 95/98 working environments.This consultant assumes that you're conversant in: * SQL*Plus instructions and common positive factors. you'll want to check with the standard SQL*Plus documentation set prior to utilizing this advisor. See "Related Documentation" later during this bankruptcy. * instructions for deleting and copying documents and the thoughts of the hunt course, subdirectories, and course names. * basics of the Microsoft home windows 2000, home windows NT or home windows 95/98 working systems.To use this consultant, you would like a easy realizing of the SQL database language. for those who do not need any familiarity with this database software, you need to discuss with the Oracle9i SQL Reference. when you plan to exploit the PL/SQL database language together with SQL*Plus, check with the PL/SQL User's advisor and Reference for info on utilizing PL/SQL.
Read Online or Download SQL Plus. Getting Started PDF
Best databases books
This e-book brings all the parts of database layout jointly in one quantity, saving the reader the time and fee of constructing a number of purchases. It consolidates either introductory and complex subject matters, thereby overlaying the gamut of database layout technique ? from ER and UML thoughts, to conceptual facts modeling and desk transformation, to storing XML and querying relocating items databases.
Oracle Call Interface. Programmer's Guide
The Oracle name Interface (OCI) is an program programming interface (API) that permits functions written in С or C++ to engage with a number of Oracle database servers. OCI offers your courses the potential to accomplish the complete variety of database operations which are attainable with an Oracle database server, together with SQL assertion processing and item manipulation.
Oracle Warehouse Builder 11g: Getting Started
This easy-to-understand instructional covers Oracle Warehouse Builder from the floor up, and faucets into the author's huge adventure as a software program and database engineer. Written in a peaceful type with step by step factors, plenty of screenshots are supplied during the e-book. there are lots of information and invaluable tricks all through that aren't present in the unique documentation.
Extra info for SQL Plus. Getting Started
Sample text
Spool Off turns off spooling. SPOOL OFF Run The Run option lists and executes the SQL command or PL/SQL block currently stored in the SQL buffer. RUN Cancel (CTRL+C) The Cancel option cancels an in-progress operation. Ctrl-C Exit The Cancel keyboard shortcut is only available when a SQL*Plus operation is running in the SQL*Plus session. When no SQL*Plus operation is running, CTRL+C copies selected text. The Exit option commits all pending database changes and closes the SQL*Plus application window.
Each HTML table row may contain more than one text line. Help Menu The Help menu has the following option: Option Description of Help Menu Option Command Line About SQL*Plus Displays the SQL*Plus version number and copyright information. not applicable You access SQL*Plus help from the SQL*Plus prompt. See "Accessing SQL*Plus Help" in Chapter 2. Setting Options and Values Using the Environment Dialog Choose Environment from the Options menu to display the Environment dialog which you can use to create a SQL environment statement for the current session.
Not applicable After you copy text to the Clipboard, you can paste the text into other Windows applications, such as Microsoft Excel and Microsoft Word. The Copy keyboard shortcut is only available when no SQL*Plus operations are running in the SQL*Plus session. When a SQL*Plus operation is running, CTRL+C cancels the running operation. Paste (CTRL+V) The Paste option pastes the contents of the Clipboard to the SQL*Plus command line. not applicable Note: A maximum of 3625 characters can be pasted from the Clipboard to the SQL*Plus command line during a single paste operation.