Difference between revisions of "Oracle Getting Help"

From mi-linux
Jump to navigationJump to search
 
(5 intermediate revisions by the same user not shown)
Line 2: Line 2:
 
== Online Documentation ==
 
== 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 Oracle web-server:
  
   http://oradb-srv.wlv.ac.uk/ora12c/  
+
   https://docs.oracle.com/en/database/oracle/oracle-database/19/index.html
  
The initial screen will look similar to the following figure:
+
The '''Learn About Oracle Database''' section will be of most interest for the introductory modules.
 
 
https://mi-linux.wlv.ac.uk/~cm1958/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 ==
 
== Summary so far ==
Line 29: Line 25:
 
== Next Step ==
 
== Next Step ==
  
This completes the ''Section One''. Now return to the [[Oracle_Workbook|Workbook]].
+
This completes ''Section One''. Now return to the [[Oracle_Workbook|Workbook]].

Latest revision as of 09:42, 17 September 2019

Main Page >> Oracle and SQL >> Workbook >> SQL Overview >> Getting Help

Online Documentation

Online help can be found on the Oracle web-server:

 https://docs.oracle.com/en/database/oracle/oracle-database/19/index.html

The Learn About Oracle Database section will be of most interest for the introductory modules.

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