+ 1 Alfred is an award-winning app for Mac OS X which boosts your efficiency with hotkeys, keywords, text expansion and more. Search your Mac and the web, and be more productive with custom actions to control your Mac. Use a Command Button to change a specified cell value with VBA code. Supposing you want to change value in cell A1 with adding 1, change value in cell A1 which equals to E1 plus 1, or make value in cell A1 equals to E1 after clicking the Command Button. Please do as follows to solve these problems.
SQL*Plus User's Guide and Reference Release 9.2 Part Number A90842-01
Home
Book List
Contents
Index
Master Index
Feedback
This chapter contains single pages of instructions to get you up and running after you have installed SQL*Plus.
Some Resources
Here are some resources you might find useful when working with iSQL*Plus:
iSQL*Plus Quick Start
Do the following steps to start iSQL*Plus:
Connect to the Internet or your intranet, and start your web browser.
Enter your Oracle9i HTTP Server URL, followed by isqlplus, in your web browser's Location or Address field. The iSQL*Plus URL looks like this:
If you do not know the Oracle9i HTTP Server URL, ask your System Administrator.
Press Enter to go to the URL. The iSQL*Plus Login screen is displayed in your web browser.
Enter your Oracle9i username and password in the Username and Password fields. If you do not know your Oracle9i username and password, ask your Database Administrator.
Leave the Connection Identifier field blank to connect to the default database. Enter the Oracle Net database alias to connect to a database other than the default. If restricted database access has been configured, the Connection Identifier field will be a dropdown list of available databases you can select.
Click Login to connect to the database. The iSQL*Plus Work screen is displayed in your web browser.
Now you can start entering and executing SQL, PL/SQL and SQL*Plus statements and commands in the Work screen Input area.
SQL*Plus Command-line Quick Start for Windows
Do the following steps to start SQL*Plus and connect to the default database:
Open a Windows command prompt.
At the command-line prompt, enter the SQL*Plus command in the form:
When prompted, enter your Oracle9i username and password. If you do not know your Oracle9i username and password, ask your Database Administrator.
SQL*Plus starts and connects to the default database.
Now you can start entering and executing SQL, PL/SQL and SQL*Plus statements and commands at the SQL> prompt.
Start SQL*Plus and connect to the default database.
Use the CONNECT command to specify the Oracle Net database alias (@connect_identifier) of the database you want to connect to. To do this enter the CONNECT command in the form:
Wattagio 1 7 2 full. To hide your password, enter the CONNECT command in the form:
You will be prompted to enter your password.
Alternatively, to start SQL*Plus connected to a database other than the default, enter the SQL*Plus command in the form:
To hide your password, enter the SQL*Plus command in the form:
You will be prompted to enter your password.
SQL*Plus Command-line Quick Start for UNIX
Do the following steps to start SQL*Plus and connect to the default database:
Command Tab Plus 1 92 Fm Radio
Open a UNIX terminal.
At the command-line prompt, enter the SQL*Plus command in the form:
When prompted, enter your Oracle9i username and password. If you do not know your Oracle9i username and password, ask your Database Administrator.
SQL*Plus starts and connects to the default database.
Now you can start entering and executing SQL, PL/SQL and SQL*Plus statements and commands at the SQL> prompt.
Do the following to start SQL*Plus and connect to a specified database other than the default:
Start SQL*Plus and connect to the default database.
Use the CONNECT command to specify the Oracle Net database alias (@connect_identifier) of the database you want to connect to. To do this enter the CONNECT command in the form:
To hide your password, enter the CONNECT command in the form:
You will be prompted to enter your password.
Alternatively, to start SQL*Plus connected to a database other than the default, enter the SQL*Plus command in the form:
To hide your password, enter the SQL*Plus command in the form: