Sol 3

Browse by Tags

• 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

• 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 Filed under: Oracle, Code