Database IT Blogs

Articles, tips and tricks for databases
Tags >> PL/SQL
SQLDeveloper 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.

Tagged in: PL/SQL , oracle database
SQLDeveloper
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.

Tagged in: PL/SQL , oracle database
SQLDeveloper Mentat Technologies announces the new minor update of DreamCoder for Oracle version 4.2.7.0.

Tagged in: PL/SQL , oracle database
SQLDeveloper Mentat Technologies announces the new minor update of DreamCoder for Oracle version 4.2.6.0.

Tagged in: PL/SQL , oracle database , developers
SQLDeveloper Mentat Technologies announces the new minor update of DreamCoder for Oracle version 4.2.5.0.

Tagged in: PL/SQL , oracle database , developers , DBAs
oracle-chanel 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.

Tagged in: PL/SQL , oracle database
SQLDeveloper
Mentat Technologies announces the new minor update of DreamCoder for Oracle version 4.2.4.0.

Tagged in: PL/SQL , oracle database , developers
SQLDeveloper

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.


Patrick Barel

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 figured I could use roughly the same solution but I needed to find a better way to implement it.

Read the rest of this article at http://bar-solutions.com/weblog/?p=321


Patrick Barel

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.


« StartPrev1234NextEnd »

Advertisement

Featured Links:
DreamCoder for MySQL Enterprise at USD 69.95
Powerful and easy MySQL IDE tool for Developers & DBAs.
DreamCoder for Oracle DBA at USD 99.95
The top IDE for Developers & DBAs for Oracle Databases.
DreamCoder for PostgreSQL Enterprise at USD 69.95
Powerful IDE for PostgreSQL Databases.

Tags