Oracle Getting Help

From mi-linux
Revision as of 09:10, 20 September 2016 by Cm1958 (talk | contribs)
Jump to navigationJump to search

Main Page >> Oracle and SQL >> Workbook >> SQL Overview >> 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:

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 Section One. Now return to the Workbook.