Archive for the ‘ Databases ’ 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 ]
From the Sun supported MySQL website – http://dev.mysql.com/doc/refman/5.1/en/storage-engines.html MyISAM — The default MySQL storage engine and the one that is used the most in Web, data warehousing, and other application environments. MyISAM is supported in all MySQL configurations, and is the default storage engine unless you have configured MySQL to use a different one by default. InnoDB — [ READ MORE ]