Read More......
Monday, January 12, 2009
How to Choose the Best Online Marketing Courses!
Read More......
Wednesday, June 25, 2008
Using the Graphical User Interface
To start the graphical user interface:
1. If you are connecting to a remote Oracle database, make sure your SQL*Net/networking software is installed and working properly.
2. Choose Start > Programs > Oracle for Windows NT [HOME_NAME] (or Oracle for Windows 95 [HOME_NAME]) > SQL Plus 8.0.
3. Enter your user name and password. If you are connecting to a remote Oracle database, enter the SQL*Net connect string.
4. Click OK.
The SQL*Plus application window appears.
Wednesday, May 7, 2008
Using SQL*Plus
Using the Command Line Interface
The command line interface is a standard feature of SQL*Plus for all platforms.
To start the command line interface:
1. If you are connecting to a remote Oracle database, make sure your SQL*Net/networking software is installed and working properly.
2. Start an MS-DOS command prompt window.
3. At the command prompt, enter:
4. SQLPLUS [username/password][@connectstring]
For Windows NT/95, the rules for interpreting arguments are:
• Arguments are delimited by white space.
• A string surrounded by double quotation marks (for example, "string") is interpreted as a single argument.
• A double quotation mark preceded by a backslash is interpreted as a literal double quotation mark.
Tuesday, May 6, 2008
Introducing SQL*Plus 1
Who Can Use SQL*Plus?
The SQL*Plus, SQL, and PL/SQL command languages are powerful enough to serve the needs of users with some database experience, yet straightforward enough for new users who are just learning to work with Oracle.
The design of the SQL*Plus command language makes it easy to use. For example, to give a column labelled ENAME in the database the clearer heading "Employee", you might enter the following command:
COLUMN ENAME HEADING EMPLOYEE
Similarly, to list the column definitions for a table called EMP, you might enter this command:
DESCRIBE EMP
Installing SQL*Plus
The CD-ROM insert that accompanies your product CD-ROM contains the following information:
• System requirements for SQL*Plus
• Instructions on how to install SQL*Plus
Installation of SQL*Plus version 8.0 does not overwrite previous versions of SQL*Plus that are installed. Therefore, more than one version of SQL*Plus can exist on the same computer. However, you may want to remove any previous versions.
Introducing SQL*Plus
Overview
You can use the SQL*Plus program in conjunction with the SQL database language and its procedural language extension, PL/SQL. The SQL database language allows you to store and retrieve data in Oracle databases. PL/SQL allows you to link several SQL commands through procedural logic.
SQL*Plus enables you to manipulate SQL commands and PL/SQL blocks, and to perform many additional tasks as well. Through SQL*Plus, you can:
• enter, edit, store, retrieve, and run SQL commands and PL/SQL blocks
• format, perform calculations on, store, and print query results in the form of reports
• list column definitions for any table
• access and copy data between SQL databases
• send messages to and accept responses from an end user
SQL*Plus for Windows NT/95 provides both a command line interface and a graphical user interface (GUI).