Difference between revisions of "Oracle Getting Help"
From mi-linux
Jump to navigationJump to searchLine 1: | Line 1: | ||
[[Main Page]] >> [[Oracle|Oracle and SQL]] >> [[Oracle_Workbook|Workbook]] >> Getting Help | [[Main Page]] >> [[Oracle|Oracle and SQL]] >> [[Oracle_Workbook|Workbook]] >> Getting Help | ||
− | = | + | == Online Documentation == |
Online help can be found on the oradb-srv webserver. From a Web Browser (e.g., IE, FireFox or Chrome), select the following address (available anywhere): | Online help can be found on the oradb-srv webserver. From a Web Browser (e.g., IE, FireFox or Chrome), select the following address (available anywhere): | ||
Line 12: | Line 12: | ||
Information on SQL can be found by clicking on the SQL Reference link, note the PDF versions will require Abode Acrobat Reader on the local machine. | Information on SQL can be found by clicking on the SQL Reference link, note the PDF versions will require Abode Acrobat Reader on the local machine. | ||
− | = Summary so far = | + | == Summary so far == |
By now you: | By now you: |
Revision as of 14:30, 18 February 2016
Main Page >> Oracle and SQL >> Workbook >> Getting Help
Online Documentation
Online help can be found on the oradb-srv webserver. From a Web Browser (e.g., IE, FireFox or Chrome), select the following address (available anywhere):
http://oradb-srv.wlv.ac.uk/ora12c/
The initial screen will look similar to the following figure:
http://mi-linux.wlv.ac.uk/~oracle/wiki/Documentation.png
Information on SQL can be found by clicking on the SQL Reference link, note the PDF versions will require Abode Acrobat Reader on the local machine.
Summary so far
By now you:
- Will have an Oracle account, ensure you remember your password if you have changed it
- Have been introduced to the tables and general SQL background
- Can list what tables you own
- Can carry out simple queries
- Know where to find the online help
If you cannot do any of these, please review the SQL Overview again.
For example, ensure you know how to do the following:
- Show the contents of the EMP table
- Show the structure of the EMP table
Next Step
This completes the first section. Now return to the Workbook.