From: b.f.lundin@gmail.com   
      
   In others databases, I can run   
   explain (some query)   
   and get a execution plan.   
      
   We have a tool that parses source code for   
   sql statements and runs explain on them.   
   By doing this, we get   
   * the execution plan (obviously)   
   * but also a receipt that the embedded sqls are valid.   
      
   Sometimes an sql is written differently in Oracle compared to sql-server.   
   one example is substr/substring but there are others.   
      
   Yes, I could define a function that is called substr, and implement substring   
   in sql-server, or the other way around, but I prefer to have different   
   statements then, (case Oracle => , case Sql_Server => case Postgresql => ...)   
      
   So, I'm looking for a cli tool that I could feed with a    
   sql string that it runs at least a validation check on   
      
   Suggestions?   
      
      
   --   
   Björn Lundin   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)