RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing Objects
Backup Recovery
Admin Tasks
Managing Users
«Prev
Next»
User Connectivity
Configuring Oracle
SID List Listener
Configuring Listener
Oracle Net Basic Concepts
Password Files
Necessary Password Files
Password Creation Process
Placing | Naming PW File
Creating Password File
Remote Login Password
Connecting Internal Password
DBA Privileges
Different DBA Roles
Connect Database
PW Files Data Dictionary
Rebuilding Password File
Manage PW Conclusion
Enterprise Manager
SQL Plus Worksheet
OEM Architecture
SQL* Plus CLI
Accept Prompt Commands
Spooling Printing Report
SQL Plus Line Editing Commands
Creating Users
Steps To Change Security Manager
Default Tablespaces
Drop User
What Objects does User Own
Managing User Roles
Types System Privileges
Granting System Privileges
With Admin Option Clause
session_privs View
Revoke Privileges Oracle
Managing System Privileges
Using SQLPlus Worksheet - Exercise
Objective:
Use SQLPlus Worksheet to execute a few queries.
Exercise scoring
You will receive 10 points for this exercise. The exercise is auto-scored; when you have completed the exercise, click the Submit button.
Instructions
Start SQLPlus Worksheet, connect to the
COIN
database, and execute these three queries:
select * from dual; select sysdate from dual; select user from dual;
You can execute one query at a time, or you can type all three into the upper textbox, click the lightning bolt, and execute them all at once.
Try it both ways, and observe how the results are appended to the lower textbox after each statement is executed.
Hints
Do not forget that you have to click the lightning bolt icon to execute a query.
When you do that, all the text from the upper textbox is sent to Oracle to be executed.
If you run into trouble with syntax errors, make sure that the upper textbox contains nothing but the one statement that you want executed.