Posts Tagged ‘sql’

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 […]

Saturday, May 9th, 2009 at 10:02 | 0 comments
Categories: Database
Tags: ,

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 […]

Tuesday, April 21st, 2009 at 13:48 | 1 comment
Categories: Database