Oracle Database 10g Express Edition on Ubuntu Linux (Notes)
Tested on Ubuntu Linux 7.10 Gutsy Gibbon. (2008-12-02)
Installation: Configure the database.
sudo /etc/init.d/oracle-xe configure
Stop the database.
sudo /etc/init.d/oracle-xe stop
Start the database.
sudo /etc/init.d/oracle-xe start
Access the web-interface. (Login: system)
http://localhost:8080/apex/or
http://127.0.0.1:8080/apex/
Login to the database shell. (The database has to be running!)
sqlplus system as sysdba
Execute a PL/SQL script (test.sql) in the database shell. (SQL> ...)
Be sure to change to the directory of the script before logging into the database.
@testor
start test.sql
Check the current date format. (e.g. if you have the error ORA-01843: not a valid month)
create table date_test as select sysdate dt from dual;
select dt from date_test;
Change the current date format. (example date format)
alter session set NLS_DATE_FORMAT='yyyy-mm-dd';
Related page
Oracle 10g Express Edition on Ubuntu (help.ubuntu.com)
Orafusion.com Resources