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 […]
Categories: Database
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 […]
Categories: Database