Difference between revisions of "Oracle:Apps Anywhere"

From mi-linux
Jump to navigationJump to search
Line 14: Line 14:
  
 
== Apps Anywhere ==
 
== Apps Anywhere ==
The Oracle database can be accessed via different clients. When using the software at the University, it is available via the Applications Anywhere software hub:
+
SQL*Plus is available via the Applications Anywhere software hub:
 
[[http://www.wlv.ac.uk/appsanywhere Apps Anywhere]]
 
[[http://www.wlv.ac.uk/appsanywhere Apps Anywhere]]
  
Line 23: Line 23:
 
https://mi-linux.wlv.ac.uk/~oracle/wiki/AppsAnywhereIcon.png  
 
https://mi-linux.wlv.ac.uk/~oracle/wiki/AppsAnywhereIcon.png  
  
If you are using Apps Anywhere off-site, you will need to install the VPN software first.
+
=== VPN ===
 +
If you are using Apps Anywhere off-site, you will need to install the VPN software first. See this link for details on how to do this:
  
 +
[[http://mi-linux.wlv.ac.uk/~oracle/wiki/Installing_the_VPN_Client.pdf Installing the VPN Client]]
  
 
Once you have been validated, a new window will appear showing all your available apps:
 
Once you have been validated, a new window will appear showing all your available apps:
Line 30: Line 32:
 
https://mi-linux.wlv.ac.uk/~oracle/wiki/AppsAnywhereV2.png  
 
https://mi-linux.wlv.ac.uk/~oracle/wiki/AppsAnywhereV2.png  
  
Look for the '''Oracle''' icon:
+
Given there are a lot of apps, use the ''Search Apps'' box to search for: '''Oracle'''
  
 
https://mi-linux.wlv.ac.uk/~oracle/wiki/AppsAnywhere-Oracle.png  
 
https://mi-linux.wlv.ac.uk/~oracle/wiki/AppsAnywhere-Oracle.png  
 
 
Note: if it is not appearing on your list, use the ''Search Apps'' box and search for: '''Oracle'''
 
  
  

Revision as of 20:14, 28 September 2020

Main Page >> Oracle and SQL >> Workbook >> Getting Started >> Apps Anywhere

SQL*Plus

The Oracle database can be accessed via different clients. SQL*Plus is one of the clients and can be used in a number of ways:

  1. Apps Anywhere
  2. mi-linux.wlv.ac.uk
  3. Download the software from Oracle (Called Instant Client)

For options 2&3 please see this link for further details: [Using Oracle from Home]

Apps Anywhere

SQL*Plus is available via the Applications Anywhere software hub: [Apps Anywhere]

See this page: [Access software on and off campus] for more information about this.

If you are in one of the University labs, click the Apps Anywhere icon on your desktop:

AppsAnywhereIcon.png

VPN

If you are using Apps Anywhere off-site, you will need to install the VPN software first. See this link for details on how to do this:

[Installing the VPN Client]

Once you have been validated, a new window will appear showing all your available apps:

AppsAnywhereV2.png

Given there are a lot of apps, use the Search Apps box to search for: Oracle

AppsAnywhere-Oracle.png


Click on Launch and it will install as a group of 3 tools.

For this workbook we shall be using: SQL*Plus

Note, you may have to install this for every PC that you use.

Oracle Program Menu

Once SQL*Plus has been installed you should find it has been added to your program menu also:

MenuOptions.png

In which case you can start the program by clicking on:

  Start>All Programs>Oracle>sqlplus

Next: Accessing Oracle using SQL*PLus

The next step is to login using the SQL*Plus software:

Using SQL*Plus