Um patch para o SQL Navigator 6.7

Para quem usa o SQL Navigator 6.7 e tem notado que "às vezes" prende, tal parece ter origem na "feature History" que guarda os SQL (tec..) efetuados e permite uma pesquisa nos mesmos. É possivel efetuar uma "limpeza dos comandos efetuados" antes de uma data data ou toidos de modo a evitar que o ficheiro fique muito grande (parece que apartir de 600K é que o problema é encontrado) "Before you deleting your history file, you can have a backup if needed, the history file is in: xp: C:\Documents and Settings\UserName\Application Data\Quest Software\SQL Navigator 6.6.0\Unified Editor\history win7: C:\Users\UserName\AppData\Roaming\Quest Software\SQL Navigator 6.6.0\Unified Editor\history" Hoje, no entanto, foi libertado um patch: "We would like to provide you the new binary which fixes the hang issue with the history file as reported. The new v6.7 binary build 2375 is now available for download: http://sqlnavigator.inside.quest.com/shares/sqlnavigator/sbin/GA/6_7_Patch/2375/sqlnavigator.zip (8MB) Please rename your current v6.7 .exe file, then copy the new sqlnavigator.exe into v6.7 installation folder. Much appreciated if you could please let us know you are all happy with the changes." Esperemos que a correção funcione a 100%. Boa codificação!

SQL Navigator 6.7 released

Quest Software released the 6.7 version of SQL Navigator. Mainly it corrects some bugs.

SQL Navigator 6.7 Beta available

Quest Siftware released to the community a beta version for SQL Navigator 6.7. If you have a previous beta version installed, you can upgrade it with this build. You can (and should) install this side by side with your current 6.6 (or previous) version. Read all about it

Oracle Magazine January-February 2012 online versions

Oracle Magazine January-February 2012:
Flash version
HTML version

TIOBE Programming Community Index for February 2012

PL/SQL is on the 17th place TIOBE Index (February 2012).
It's was 32nd in February last year (February 2011)!
In 2008 and 2007 in February it was in 13th position in the index.

SQL Navigator 6.6 released

Quest Software released the 6.6 version of SQL Navigator. Mainly it corrects some bugs.
The most usefull new feature is in the history search (where you can search the runned scripts/commands for an expression) to filter the commands by type.

Check the Release Notes and the Known Issues List.

TIOBE Programming Community Index for December 2011

PL/SQL is on the 14th place TIOBE Index (december 2011).
It's was 23st in November last year.
It was in 13th in 2008 and 2007 in the same month!

Oracle Magazine November-December 2011 online versions

Oracle Magazine November-December 2011:
Flash version
HTML version

TIOBE Programming Community Index for November 2011

PL/SQL jumped to the 12nd placeTIOBE Index (november 2011).
It's was 20st in November last year.

Oracle Database 11g Release 2 Express Edition Available

Oracle Database 11g Release 2 Express Edition (Oracle Database XE) final version is available. It's "an entry-level, small-footprint database based on the Oracle Database 11g Release 2 code base. It's free to develop, deploy, and distribute; fast to download; and simple to administer." Download Documentation Do not forget to check the Open Bugs and Known Issues section.

Oracle Magazine September - October 2011

HTML version
Flash version

TIOBE Programming Community Index for August 2011

PL/SQL is again in the 22nd place TIOBE Index (August 2011).
It's was in 21st last month.

QuestTV

Quest Software site has recently make available a new section in its website called QuestTV with several videos about its services and products. Some of these videos are also available in Quest Software Channel in YouTube.

Most interesting videos for PL/SQL developers:

Using Toad for Oracle with Oracle Instant Client (this series is helpful even for people that do not use TOAD but want to install and configure Oracle Instant Client.

• Using Oracle Instant Client
  
• Configuring a TSNAMES file for Oracle Instant Client
  
• Removing Oracle Instant Client
  

• Using SQL Tracker available with TOAD or SQL Navigator
  

Steven Feuerstein (renowned PL/SQL expert :-)) videos:

• Common Mistakes in Oracle PL/ SQL Programming
  
• PL/SQL Best Practices
  
• Practical Best PL/SQL 1- Overall perspectives on writing software
  
• Practical Best PL/SQL 2- Establish a foundation of shared code for team development
  
• Practical Best PL/SQL 2A- Applying coding standards and naming
  
• Practical Best PL/SQL 2B - SPODify your code - aim for a Single Point of Definition
  
• Practical Best PL/SQL 2C- Manage exceptions with shared utility
  
• Practical Best PL/SQL 2D- Break your addiction to SQL - Part 1
  
• The Path to Unit Testing Happiness
  
• Code Tester Version 2 new features

About Spotlight on Oracle (a tool normally used by DBA's but also by some Developers :-) )

• Introduction
  
• About Spotlight Bundles
  
• Spotlight Basics
  
• SQL Optimization
  
• Use Cases
  

TIOBE Programming Community Index for July 2011

PL/SQL is again in the 21st place TIOBE Index (July 2011).
It's was in 22nd last month.

Missing features in PL/SQL

I love PL/SQL but there are some missing features that very annoying:

- Result cache is very nice but restrictions like authid CURRENT_USER (CLOB, BLOB) should only make the cache algorithm not to be applied but not issuing an compilation error (giving only a compilation pls warning) so the code could be prepared for future implementation of the result cache without those restrictions.
The use of VPDs should be 100% transparent with Result cache, i.e. using VPD should not imply a change in the code to work correctly!

- Conditional compilation is nice but cannot check if the oracle version is 11.2.0.2 (or above) only can check 11.2 and oracle implemented new features (like UTL_SMTP using TLS/SSL connection) in that new “patched” version. (here the problem is the missing global constant for anything “below” the minor number or maybe the numbering of that version)

- Automatic detection of "pure" user-defined PL/SQL functions for parallelism (in parallel queries) for functions in packages (like Oracle does for stand-alone (not in package) functions).


BTW: Editions look great but we encounter a bug that “corrupted” the catalog and so the DBAs are not confident to continue to use it for now.

Digital version of Oracle Magazine July/August 2011 is available

Digital version of Oracle Magazine July/August 2011 is available.

	Look inside >
July/August 2011

TIOBE Programming Community Index for June 2011

PL/SQL in 22nd place in TIOBE Index for June 2011.
It's was in 13th place last year (June 2010) and 21st last month (May 2011).
It was 14th in June 2008 and 11th in June 2007.

APEX Listener Release 1.1.2 released

APEX Listener Standard Configuration

In May, a new version of APEX Listener was released.
It fixes some bugs like:

• Fixed flexible parameter support to handle POSTs without requiring a query string to be present in the submitted URI.
• Fixed a problem with the standalone Listener where the location of the images folder could not be overwritten.
• Fixed a problem with character encoding when consuming HTML forms submitted using the multipart/form-data content-type.
• Fixed a problem with an IllegalStateException being thrown when the path /apex (instead of /apex/) was accessed on the standalone Listener.

As always you can download the last version at OTN.

APEX Listener Advanced Configuration

TIOBE Programming Community Index for May 2011

PL/SQL in 21st in TIOBE Index for May 2011.
It's was in 14th place in May 2008 and 24th last month.

SQL Navigator 6.5 released

Quest released a new version of SQL Navigator. Mainly it corrects bugs and some new features (like the filter in the history and the join of the 6.3 DB filter with the 6.4 version).

Check the Release Notes and the Known Issues List.