Sol 3

Browse by Tags

• Code
• SQL

• SELECT TOP [x] Records

  When you use one database platform long enough you start to think everything you do is ANSI SQL-92 compliant. Until you switch database platforms that is! Then you find the simple things no longer work. Take for example the TOP clause used so often in Read More... Posted Tuesday, April 10, 2007 9:16 AM by Keith Barrows | 0 Comments

• access to oracle without tnsnames.ora

  This is a slick little trick to get around the need for a complete TNSNAMES.ORA file: Have you ever tried to access an oracle instance in VBScript? This is not to complicated, but normally you need an additional file called tnsnames.ora in the oracle Read More... Posted Monday, April 02, 2007 12:56 PM by Keith Barrows | 0 Comments Filed under: Oracle

• Oracle command Line tool to run *.SQL files?

  Found it. Buried in a forum posting somewhere... @echo off FOR %%f IN (.\sql\tab1\*.sql) DO exit | sqlplus [uid]/[pwd]@[db] @ " %%f " FOR %%f IN (.\sql\tab2\*.sql) DO exit | sqlplus [uid]/[pwd]@[db] @ " %%f " Add " exit | " to the beginning of the command Read More... Posted Thursday, March 29, 2007 7:54 AM by Keith Barrows | 0 Comments

• Importing a DMP file into Oracle

  This is more for my own notes but you are welcome to glean from it what you can. There are a couple main steps involved in pumping a DMP file back into a blank Oracle database. Round up the user, schema and tablespace info Create the tablespaces Create Read More... Posted Wednesday, March 21, 2007 12:16 PM by Keith Barrows | 0 Comments Filed under: Oracle