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

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.

First public Beta version of SQL Navigator 6.6

SQL Navigator 6.6 Beta build 2220 (expires 31 Oct 2011) is now available! See the full announcement.

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
  

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.

Final Beta of SQL Navigator 6.5 (2)

Another (!) Final Beta version of SQL Navigator 6.5 was made available

We decided to do another beta release to include a few more changes.
(...)
Issues resolved in this release:
--------------------------------
Ability to handle user defined DUAL tables
Bug fixes with data export
View Difference: ability to enter SchemaName.ObjectName for comparing

Source

Final Beta of SQL Navigator 6.5

The previous Beta Navigator 6.5 will expire in 31st March but you can download the final beta.

Some issues resolved in this release:
-----------------------------
dbms_output : not showing output generated before error until next SQL is run
Filter Issues in DB Nav Tree : make consistent with DBExplorer
Right-click out of the highlighted area and selection is lost
When you try to highlight the code with mouse and drag off the bottom, selection is lost
View Difference Report - Should add 'No differences found" if objects are identical."
Bind Variables window doesn't exist when Scan Defines/substitution" is on
Bind Variable Window can't remember modes and types of parameters set previously
Make BFILE read-only
Add Disable menu for Constraints and Triggers in Table Editor VOE
Deleting filters still shows in filter list
Add a Disable button to Constraint Editor
Open file dialogue file, set default for file type
Issue with mouse click and shortcut menu when using dual monitor
Degraded performance of Nav on large databases (3000 users), when Show Users in Schema List" preference is set ON."
Add ability to export entire column of BLOB data like Toad for Oracle.
Include a DROP FORCE clause for type object
Could not open package object with parameters of type when having NO permission to see the type object.
SQL Nav hangs on long running query + Explain Plan+View Differences
Bug on tree refresh in DB Explorer on saved filter
Have checkbox in filter to use case & ignore case by default
DBX Filter did not take into account lower case object name
Can't save Filter in DBX if it has % symbol in name
Add process for object being formatted in the task manager so user can stop it if it takes too long
DBX filter shows current schema in Other Schemas
% in selected schema name in the Full filter - does not work in DB Explorer
Object status is not correct and it cannot be saved
The status of Extract DDL was not modified and save button was disabled, can close it without any confirmation.
Formatter: focus position becomes wrong after formatting invalid text
Editor pane does not show results as split pane
Maintain the size of the data grid after user change for multi sql execution

See full announcement

Second Public Beta of SQL Navigator 6.5

Second Public Beta of SQL Navigator 6.5 (6.5.0.2032) is now available.

First Beta of SQL Navigator 6.5

Quest announced the release of the first beta of SQL Navigator 6.5.

Some problems already reported by users (in the Beta forum and support) are already fixed and some others are in resolution.

Some of the problems (and lacking features) that I found annoying in previous versions that were fixed are:
- Multi lines dbms output is not highlighted completely in Spool
- Close Code Editor when closing the last remaining tab - new preference included
- Quoted object name is mixed up with normal object name in object selector
- SQL navigator hang when print code editor
- Open File windows to have the same list of file types
- Find Recycle bin Objects is not disabled when Find Objects is running
- Allow to stop Code Search when searching
- Date is cut off when export from data grid
- Add shortcuts to View Differences

As usual the beta versions are not to be used in production systems and any feedback should be given by the beta forum.
Download and start testing!

SQL Navigator Tips and Tricks videos

Quest software has a series of videos called "Toad Tips and Tricks Video Series" that provide Tips that can also be used with SQL Navigator (so it could be used for a "SQL Navigator Tips and Tricks videos Series" :-) ).
Two of those features are the Quest SQL Tracker (called Oracle SQL Tracker in TOAD) and the Code Roadmap.

I really like Quest SQL Tracker because it allows to capture the SQL statements being executed from windows applications running against the Oracle database, see a list of the bind variables issued from those statements, associated times, etc..

How to check the pl/sql web output

If you use the pl/sql web toolkit sometimes you will want to check the web output that you are creating.
You can use a browse, but maybe you do not have a web server (with the pl/sql gateway) or the EPG configured, or you want to unit test inside PL/SQL or to see the result before pl/sql gateway mess with the http header.

SQL Navigator 6.4 released

Quest released a new version of SQL Navigator. Mainly it corrects some bugs and redefines the filters use (now you have to save the filter before using it, but stores the filters from session to session).
Warning: don't name you filter using the % sign (doesn't work = bug already reported).

Check the Release Notes.

SQL Navigator 6.3.1 available

You can find here a download link for SqlNavigator 6.3.1 version.

"v6.3.1 patch will be released on our Support Link site soon, and it is available on request. The patch fixed the following items:

- The data grid could not handle large dataset, and Exporting large number of rows and when export finishes, SQL Navcloses.
- Formatter:  formats wrong after the package/procedure separator
- Request to support User Profile with TNS_ADMIN=%USERPROFILE%
- Issue with tab chars and executing a selected SQL.
- SQL*Plus command highlight were  broken (Regression 6.2)
- Nav 6.2.1 does not return "single row subquery returns more than onerow"
- Error with opening Tablespaces node"

SQL Navigator 6.3 released

New features of SQL Navigator version 6.3 include:

* Automated Code Testing - allows you to describe the expected behavior of a program and have the required code for the test case generated - test definitions are stored in a repository so that you can easily update them when required
* Debugging Triggers - gives you more options in which you can use debug triggers - through DBMS_OUTPUT or the optional PL/SQL Debugger - when using a trigger is only fired by activating the particular SQL DML operation (INSERT. DELETE or UPDATE) that the trigger was designed to respond to, and can be done using INSERT. DELETE or UPDATE statements executed from an anonymous PL/SQL block
* New Tablespace Editor - now includes a tablespace VOE to manage tablespace objects, which can be created, edited and dropped - additional information on Data Files and Disk Groups is also available
* New Quest SQL Tracker - monitors SQL statements issued by Windows applications and services that access Oracle

There were also some bug fixes and some enhancements in Code Editor and Trigger editor.

How to kill the right SQL Navigator session

Hi

If you have several SQL Navigator Sessions and want to kill one of them due to something (normally SQL Navigator hanged or is doing something and will not abort) try this:
1- open Quest SQL Tracker
2- select all the SQL Navigator processes
3- check which session is not the ones you want to maintain (for that you could, for instance, make a 'select 1 from dual' )
4- check the PID....and using windows's task manager kill the session with that PID (maybe you need to include that column in the task list)

it was very helpful today...

Knowledge Xpert for Oracle

Quest Software lançou um Knowledge Xpert for Oracle subsite web (Oracle Administration e PL/SQL Development) que contêm o conteúdo das aplicações "Knowledge Xpert for Oracle for Oracle Administration" e "Knowledge Xpert for Oracle for PL/SQL Development" que estavam disponíveis no TOAD e SQL Navigator (às vezes somente mediante licenciamento não standard).

Agora essa informação, baseada, na sua maioria dos casos, nos livros do Steven, está disponível gratuitamente e com possibilidade de discussão (mediante introdução de comentários sobre cada tópico) à comunidade. Aproveitem este recurso!

Boa codificação!

SQL Navigator 6.2.1 released

Some of the fixes included in 6.2.1 are:

# AV in table editor for object table
# Error "ORA-00900: invalid SQL statement: SQL Navigator could not parse/execute sql with open '(' after FROM.
# AV when editing and switching between script and results tab
# In data grid, Exporting large number of rows and when export finishes, SQL Nav closes.
# The focus is not on the currently running query
# Output doesn't get displayed if debug from the body tab
# Updateable mode doesn't work if column name is similar to a keyword (regression)
# Out of memory when query from table with large amount of columns (regression)
# Issue with Ldap using 11G client
# Debugger hang when input a decimal number in German Regional setting
# Invalid variant operation when open/extract ddl from external table (regression)
# Data corrupted when export from excel
# AV when editing a sql file (regression)
# Cannot access trigger in another schema in 9iDB (Regression)
# Dot lookup doesn't work for synonym of a table belong to a different schema (Regression)
# Reset Oracle password under Session main menu is broken in v6.2.

SQL Navigator 6.2 released

SQL Navigator 6.2 was released

Some new features:

• New Search feature for the Preferences window.
• Preference to format after extracting the ddl.
• Import/Export tables.
• Session browser to support RAC database.
• Revised layout to accommodate multiple code editor windows.
• Code Editor - Bug fixes and enhancements.
• Other General bug fixes and enhancements.