DreamCoder for Oracle minor update ver 4.4.1.5 available for download

SQLDeveloper — Fri, 29 Jan 2010 17:42:03 +0100

Mentat Technologies announces the new minor update of DreamCoder for Oracle version 4.4.1.5.
This version includes:

   * PL/SQL Syntax highlight configuration option fixed
   * Several bugs with Direct TCP-IP connection mode fixed
   * Other SQL and PL/SQL editor improvements
   * Other small improvements and bug fixes

You can download DreamCoder for Oracle at:

New PL/SQL options in the DreamCoder for Oracle ver 4.4

SQLDeveloper — Mon, 25 Jan 2010 23:10:06 +0100

The new version of the DreamCoder for Oracle include some advanced options to improve the work with PL/SQL.

Mark object option ( Video demo):

SQL Syntaxt Tree option (video demo):

DreamCoder for Oracle Ver 4.4 available for download

SQLDeveloper — Sat, 23 Jan 2010 00:28:46 +0100

Mentat Technologies is happy to announce the new version of DreamCoder for Oracle version 4.4, a powerful oracle database tool for administration and development.

This new version includes more than 20 new features and improvements over the previous version.
SQL & PL/SQL Editor:

* New object types supported
* New SQL Syntax tree option for the PL/SQL editor
* New Highlightling options
* New Object mark code option
* Debugger call fixed in the SQL ediRead More...

DreamCoder for Oracle ver 4.3 available for download

SQLDeveloper — Tue, 03 Nov 2009 18:08:03 +0100

Mentat Technologies is happy to announce the new version of DreamCoder for Oracle version 4.3, a powerful oracle database tool for administration and development.

This new version includes more than 40 new features and improvements over the previous version.
New features :

* Add support to view context
* Add support to create,edit and drop context
* Add support to table polices
* Add support to view table auditing
* Add support to create,edit Read More...

Follow Oracle Openworld at Twitter

oracle-chanel — Fri, 30 Oct 2009 21:14:28 +0100

Get the inside scoop, important announcements, and valuable tips and tricks for making the most of your experience at Oracle OpenWorld.

http://twitter.com/oracleopenworld

The OTN Guide to Oracle OpenWorld & Oracle Develop 2009

oracle-chanel — Fri, 30 Oct 2009 21:07:20 +0100

Missed Oracle OpenWorld? You can still bask in the afterglow by following the community streams that continue to flow from, and around, the conference.

http://www.oracle.com/us/openworld/034626

Migrating from Oracle to Postgres Plus Advanced Server

postgresql-chanel — Thu, 29 Oct 2009 21:31:00 +0100

Watch Craig Silveira (Director, Sales Engineering, EnterpriseDB Corporation) as he uses the GUI-based Migration Studio to migrate the HR demo database from Oracle Express Edition to Postgres Plus Advanced Server. After migration Craig demonstrates simple command line tools to resolve common troubleshooting issues.

http://www.sqlplex.com/videos/postgresql-chanel/videos/postgresql/migrating-from-oracle-to-postgres-plus-advanced-server.html

DreamCoder for Oracle ver 4.2.7 available for download

SQLDeveloper — Fri, 25 Sep 2009 16:57:32 +0100

Mentat Technologies announces the new minor update of DreamCoder for Oracle version 4.2.7.0.
This version includes:

   * Add support for two explain plan scripts
   * Enhanced query builder
   * Enhanced SQL editor
   * Other small fixes and improvements

You can download DreamCoder for Oracle at:
http://www.sqldeveloper.net/database-tools/products/download-center.htRead More...

DreamCoder for Oracle ver 4.2.6.0 released

SQLDeveloper — Fri, 18 Sep 2009 22:43:29 +0100

Mentat Technologies announces the new minor update of DreamCoder for Oracle version 4.2.6.0.
This version includes:

   * Enhanced Query Builder
   * Fixed START WITH syntax in The Query Builder
   * Fixed OCI message at the register connection
   * Minor improvements and bugfixes

You can download DreamCoder for Oracle at:
http://www.sqldeveloper.net/databRead More...

DreamCoder for Oracle ver 4.2.5 released

SQLDeveloper — Fri, 11 Sep 2009 17:13:59 +0100

Mentat Technologies announces the new minor update of DreamCoder for Oracle version 4.2.5.0.
This version includes:

   * Enhanced Lov Viewer
   * Enhanced Query Builder
   * Enhanced syntax highlight
   * Minor improvements and bugfixes

You can download DreamCoder for Oracle at:
http://www.sqldeveloper.net/database-tools/products/download-center.html

Hope you will enjoy workRead More...

Now Available: Oracle Database 11g Release 2

oracle-chanel — Thu, 10 Sep 2009 15:53:12 +0100

The latest generation of the world’s number-one database builds on the innovations introduced in Oracle Database 11g to help organizations deliver better information throughout the enterprise, at a higher quality of service, and at much lower cost.
Learn more. Download Oracle Database 11g Release 2 from the Oracle Technology Network.

DreamCoder for Oracle ver 4.2.4 released

SQLDeveloper — Fri, 04 Sep 2009 16:34:04 +0100

Mentat Technologies announces the new minor update of DreamCoder for Oracle version 4.2.4.0.
This version includes:

* Improved load time for other shcemas object
   * Fixed the problem with the search object option
   * Fixed problem with the view scripts
   * Enhanced Query Builder
   * Bug with converting EOL fixed
   * OCI functions fixed
   * Fixed bug with parsing sRead More...

New Release of DreamCoder for Oracle 4.2

SQLDeveloper — Sun, 16 Aug 2009 23:28:38 +0100

Mentat Technologies is happy to announce the new version of DreamCoder for Oracle version 4.2, a powerful oracle database tool for administration and development.

Its flexibility and compatibility, in addition to a low price-point, make it a must-have tool for application developers who are increasingly working with oracle databases.

New features :

* Improved stability in a unstable network
* Enhanced stability in a VPN connection
* New reconnect optioRead More...

Semaphores (revisited)

Patrick Barel — Tue, 04 Aug 2009 07:00:00 +0100

In a previous blog I talked about turning triggers on and off using semaphores. I created a semaphore for every table I needed along with its programs to set and unset the semaphore and to get its current state. This was a rather cumbersome process, because for every new trigger I needed to add these programs to the package. Both the spec and the body need to be recompiled which renders all dependant code to become invalid. This week I came across a similar problem with a new project. I figurRead More...

Database Event Triggers

Patrick Barel — Tue, 04 Aug 2009 07:00:00 +0100

Currently I am working on an application that runs one or more listener threads using scheduled tasks (DBMS_SCHEDULER). When I want to compile a piece of code that is effectively locked by one of these processes my IDE locks up, until I shut down the tasks. The first couple of times I was wondering what was happening and why my code wouldn’t compile. In a later stage I found out that the scheduled tasks was the problem.

It was rather easy to fix this issue. Just stop all the runRead More...

OracleClient not more

oracle-chanel — Thu, 09 Jul 2009 23:37:03 +0100

As a part of formulating our long term strategy for ADO.NET, we have had several discussions with number of our customers, internal and external partners, and MVPs to better align our development efforts to ensure we are delivering the right technologies according to our customers’ highest priority needs. One of the key intent of these discussions and the associated research was to understand the needs and requirements of customers who develop applications with Oracle using “System.DRead More...

Oracle vs. MySQL

MySQL Channel — Thu, 09 Jul 2009 23:34:02 +0100

As MySQL continues to explode in the marketplace, there are more Oracle and SQL Server DBAs learning MySQL. For Oracle DBAs, its important to understand that MySQL is a different type of database server.Oracle is the aircraft carrier of database servers.

Oracle has by far more features than any other database server. Oracle supports a number of database server solutions such as Real

Differences between Oracle and MySQL

MySQL Channel — Thu, 09 Jul 2009 23:31:25 +0100

Some key differences for DBAs between Oracle and MySQL database servers include:Different tools used to manage and monitor database servers.Oracle architecture is process based, MySQL architecture is thread based.Different tools used for backup and recovery.

Database specific SQL syntax.Database specific SQL functions.Different syntax for stored routines. MySQL has no packages.

DreamCoder for Oracle ver 4.1 released

SQLDeveloper — Mon, 08 Jun 2009 07:00:00 +0100

Mentat Technologies is happy to announce the new version of DreamCoder for Oracle version 4.1, a powerful oracle database tool for administration and development.

Its flexibility and compatibility, in addition to a low price-point, make it a must-have tool for application developers who are increasingly working with oracle databases.

New features :

* New Query builder variable handling
* Enhanced SQL editor
* Query builder NULLS FIRST add
* Query bRead More...

DreamCoder for Oracle version 4.0.7.0 released

SQLDeveloper — Mon, 20 Apr 2009 07:00:00 +0100

Mentat Technologies announces the new minor update of DreamCoder for Oracle version 4.0.7.0.

Features of the new DreamCoder for Oracle tool include:

    * Enhanced data grid menu options
    * Enhanced Query Builder
    * New database grid options
    * Fixed problem with F4 option
    * Fixed bug with advanced filter builder
    * Fixed problRead More...

Blog entries tagged oracle database