Difference between revisions of "Oracle Getting Help"

From mi-linux
Jump to navigationJump to search
Line 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
= 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 15: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.