segunda-feira, 5 de setembro de 2011

Working with the Oracle SQL Developer 3.0 DBA Navigator

http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/sqldev/r30/SQLdev3.0_DBANavigator/sqldev3.0_Navigator.htm

quinta-feira, 4 de agosto de 2011

Implicit COMMIT occurs with

DCL (Data Control Language) and DDL (Data Definition Language) statements cause an implicit commit when issued.

DCL statements consist of commands such as GRANT and REVOKE and are used to control access to the database and data.

DDL statements are used to create database objects and consist of statements like CREATE, DROP, ALTER, and RENAME.

quarta-feira, 20 de abril de 2011

classes12.jar, ojdbc14.jar, ojdbc5.jar and ojdbc6.jar

Differences between classes12.jar, ojdbc14.jar, ojdbc5.jar and ojdbc6.jar
We are planning to upgrade our application servers to a new version you need to look at our Oracle JDBC drivers as well.

classes12.jar - for Java 1.2 and 1.3

ojdbc14.jar - for Java 1.4 and 1.5

ojdbc5.jar - for Java 1.5

ojdbc6.jar - for Java 1.6