Archive for the ‘ Oracle ’ Category
set verify off feedback off pagesize 0 heading off linesize 4000 trimspool on trimout on wrap on serveroutput off arraysize 1 set verify off feedback off pagesize 0 heading off linesize 4000 trimspool on trimout on wrap on serveroutput off arraysize 1 [ READ MORE ]
From http://download.oracle.com/docs/cd/B19306_01/server.102/b15658/strt_stp.htm#CFAHAHGA 2.2.2 Automating Database Startup and Shutdown on Other Operating Systems To automate database startup and shutdown by using the dbstart and dbshut scripts: Log in as the root user. Edit the oratab file for your platform. To open the file, use one of the following commands: On Solaris: # vi /var/opt/oracle/oratab On AIX, HP-UX, Linux, and Tru64 UNIX: # vi /etc/oratab Database entries [ READ MORE ]
http://littlebrain.org/2008/05/12/how-to-install-oracle-xe-in-ubuntu-64-bit/ http://forums.oracle.com/forums/thread.jspa?threadID=848385&tstart=45 This is nothing to worry about – update-rc.d: warning: /etc/init.d/oracle-xe missing LSB style header After it’s been installed, configure it: sudo /etc/init.d/oracle-xe configure Configure stuff, I used all defaults I believe. Next in order to run sqlplus to do anything you need to source the config file: source /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/oracle_env.sh Which in turn gave me this error: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nls_lang.sh: 114: [[: not found Which is [ READ MORE ]
sqlplus -S username/pw@sid @sqlfile.sql outputfile.txt args [ READ MORE ]
http://en.wikipedia.org/wiki/DUAL_table http://www.oracle.com/technology/pub/articles/10gdba/week7_10gdba.html [ READ MORE ]
Very good example(s) for connecting to an Oracle DB, submitting a statement, and printing the results. http://www.java2s.com/Code/Java/Database-SQL-JDBC/DemoResultSetOracle.htm Don’t know what this next one is but it looks important http://www.oracle.com/technology/sample_code/tech/java/codesnippet/jdbc/refcur/index.html [ READ MORE ]