Wilmire.com - Computer Info » Database http://www.wilmire.org/computer-info Thu, 26 Aug 2010 12:48:33 +0000 en hourly 1 http://wordpress.org/?v=3.0.1 Oracle SQL Developer http://www.wilmire.org/computer-info/?p=6 http://www.wilmire.org/computer-info/?p=6#comments Tue, 24 Jul 2007 14:56:34 +0000 cwilmire http://wilmire.org/computer-info/2007/07/24/oracle-sql-developer/ Oracle SQL Developer is a free graphical tool for database development.

http://www.oracle.com/technology/products/database/sql_developer/index.html

]]> http://www.wilmire.org/computer-info/?feed=rss2&p=6 0 Oracle XE 10g http://www.wilmire.org/computer-info/?p=5 http://www.wilmire.org/computer-info/?p=5#comments Tue, 24 Jul 2007 14:54:11 +0000 cwilmire http://wilmire.org/computer-info/2007/07/24/oracle-xe-10g/ Oracle’s free version of the 10g database engine.

http://www.oracle.com/technology/products/database/xe/index.html

]]> http://www.wilmire.org/computer-info/?feed=rss2&p=5 0 Concatenating CSV files http://www.wilmire.org/computer-info/?p=4 http://www.wilmire.org/computer-info/?p=4#comments Wed, 14 Mar 2007 14:25:41 +0000 cwilmire http://wilmire.org/computer-info/?p=4 Many programs will log data to a CSV (comma separated value) file. These files are usually structured with a standard format. Let’s say you want to import the data into a database or spreadsheet. There is an alternative to importing 2, 5, 10 or 100+ files one at a time. You can concatenate the files into one file. Here is how you do it…

  1. Create a new directory on your hard drive (ie: C:\CSV-Files)
  2. Copy all the files into a new directory.
  3. Open a command window by clicking Start->Run. In the open line type “cmd” and hit return
  4. CD to the directory you created in step one (ie: cd C:\CSV-Files)
  5. Copy all the files to a single file… copy *.csv consolidated.csv
  6. You can now import consolidated.csv into your database or spreadsheet.
]]> http://www.wilmire.org/computer-info/?feed=rss2&p=4 0