Difference between revisions of "Oracle:Apps Anywhere"
Line 14: | Line 14: | ||
== Apps Anywhere == | == Apps Anywhere == | ||
− | + | 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 | ||
− | + | 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 | ||
− | |||
− | |||
− | |||
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:
- Apps Anywhere
- mi-linux.wlv.ac.uk
- 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:
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:
Once you have been validated, a new window will appear showing all your available apps:
Given there are a lot of apps, use the Search Apps box to search for: Oracle
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:
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: