Re: OO vs. RDB challenge

alex99_at_medcentral.com.au
Date: 03/21/05 

Date: 20 Mar 2005 18:18:00 -0800

frebe wrote:

> >>There are a standard named ANSI SQL. All major database
> >> vendors supports a very large subset of this standard.
> > Really, that's news to me. Everytime I use SQL I get bitten by
vendor
> > specifics.
> I have recently converted a large enterprise application originally
> written for Informix, to support Oracle and SQL Server as well.
99,99%
> of the SQL statements are identical for all dialects.

In your SQL statements did you use any of Oracle's date related
functions? They where screwed up in version 3, they are still screwed
in version 9.

Are the Date (and most other) functions part of the ANSI standard?

Relevant Pages

  • DES 1.7.0 Released
    ... Datalog Educational System version 1.7.0 ... SQL statements ... for tables created with SQL statements can be ... expressions which are evaluated before ...
    (comp.lang.prolog)
  • Performance: Query optimizer producing sub-optimal result?
    ... As part of a suite of SQL statements I am trying to write a data integrity ... SELECT UID, fnCheck ... The optimizer seems to move the "DISTINCT" action in the subquery to the end ... Define a View which performs the SELECT DISTINCT part of option A. My SQL ...
    (microsoft.public.sqlserver.programming)
  • RE: Manipulating MS Access records with excel VBA + ADO
    ... Data - Import External Data - New Database query ... Select the control button view dataor edit query. ... Look for SQL button to get the SQL ... Take the SQL statements and put into a string by adding double quotes. ...
    (microsoft.public.excel.programming)
  • RE: Newline inserted?
    ... Are you processing individual SQL statements (does your file contain SQL ... DBI is not your best bet to do this. ... When I attempt to load this file into Oracle 10g using the DBI I get the ...
    (perl.dbi.users)
  • Re: How to estimate code execution time?
    ... Jeff Godfrey wrote: ... maybe some specifics on your SQL statements is in order now. ... the most obvious question would be "Did you place your SQL writes within a transaction block?". ...
    (comp.lang.tcl)