ANSI-Standard SQL

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
  

Poston Tue, 27 Mar 2007 9:10 am

I wonder if the SQL statement that is not in the ANSI standard is wrong.
cleberzumba
Location: Brasília-DF

Cleber Zumba de Souza

Poston Tue, 27 Mar 2007 9:17 am

Good morning, brother, beleza?

In my book, not that I'm wrong SQL that is not in the ANSI standard.

You can e.g. put a ROWNUM of Oracle on your SQL or a LIMIT of SQL Server.

What happens is the following: If you develop a commercial application, you want to sell for N clients, in any database, you're in trouble.

For example, create SQL with ROWNUM and have q implement SQL-Server basis, Firebird etc.

Well, there is my opinion ... This topic is interesting, who can add more information.
Trevisolli
Location: Araraquara - SP

Abraço,

Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP

Poston Tue, 27 Mar 2007 9:28 am

To complement: Database Systems that use SQL: -Apache Derby-Caché-DB2-Ingres-InterBase-MySQL-PostgreSQL-Oracle-Microsoft SQL Server-SQLite-Sybase-Informix-Firebird-HSQLDB HSQLDB database, done in Java-PointBase PointBase, relational database done in Java source: http://pt.wikipedia.org/wiki/SQL#Exemplo
Trevisolli
Location: Araraquara - SP

Abraço,

Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP

Poston Tue, 27 Mar 2007 9:45 am

The Bank accepts only ANSI standard SQL Interbase ... or not?
cleberzumba
Location: Brasília-DF

Cleber Zumba de Souza

Poston Tue, 27 Mar 2007 10:32 am

Brother, I can't say for sure, because I don't know the background the peculiarities of Interbase/Firebird.

You can find more details at: http://www.firebase.com.br/fb/if anyone here on the Forum know, também, it's only post.
Trevisolli
Location: Araraquara - SP

Abraço,

Trevisolli
OCA Oracle PL/SQL Developer Certified Associate
OCP Oracle Forms Developer Certified Professional
Araraquara-SP

Poston Tue, 27 Mar 2007 10:52 am

Due to the countless peculiarities of each bank, is very hard you develop an application independent of Bank.

There will always be specific routines, non-existent or different functions q will force you to use other means to achieve the same end.

Q always possible is good to use the more standard accepted by different banks, in case ANSI.

What goes to generalize, ok.
ARF
Location: Criciúma - SC

Poston Tue, 27 Mar 2007 11:12 am

I agree with you but that the non-ANSI standard is not wrong this is true ... agree?
cleberzumba
Location: Brasília-DF

Cleber Zumba de Souza

Poston Tue, 27 Mar 2007 11:57 am

Wrong, no, different.
ARF
Location: Criciúma - SC



Return to SQL

Who is online

Users browsing this forum: Google [Bot] and 2 guests