Posts Tagged ‘oracle’
Steps to install Oracle Express Edition (XE) database 10g on Ubuntu 11.10 (Oneiric). Download the Oracle XE deb package (free registration is required). Double click the downloaded file and select to install it. In terminal run sudo /etc/init.d/oracle-xe configure. You will be prompted to enter the following parameters: HTTP port number, database listener port number, […]
Installing Oracle BI Enterprise Edition (OBIEE) will by default also install the OC4J application server. On Windows machines, it is not installed as a service, instead it runs in a dedicated command shell window. By default, OC4J will start automatically at the session startup, not only bringing up the annoying command line window but also […]
To prompt the user for a value when running SQL statements in SQL*Plus use the & symbol. The query below will prompt for variable “name” twice: select ‘Hello ‘ || ‘&name’ from dual union all select ‘Goodbye ‘ || ‘&name’ from dual; To prompt for any given variable only once and use the entered value […]
Oracle Database XE (Express Edition, sometimes also referred to as Apex) comes with an embedded web interface for administration. By default the HTTP port of this web interface is 8080. This can be checked by running the query below when logged in as system: SQL> select dbms_xdb.gethttpport from dual; In order to change the port […]