Toad World® Forums

SQL Navigator 6.0: Spilt Window Option under Preferences


#1

I recently upgraded from 5.5 to 6.0. I like to have the results appear on a separate tab. In 5.5, I went to Preferences and under Code Editors, SQL Editors, I de-selected Split Window to Display Results. This resulted in a separate tab to show results of queries. I would like to enable the same function in 6.0, but this does not see available under Code Editors, SQL Scripts. Can you tell me to fix this?


#2

Hi Betsy,

This feature was missing in 6.0 and there’s no work-around for it. Change request has been raised to bring back this feature in a future version.

Gwen


#3

Hi Betsy,

There is an expand the data grid option which you might like to check it out. It would give you more real estate with the data grid as attached. Hope that it would help for now until we can provide you the changes.

We would like to suggest that you upgrade to v6.2.1 which has fixed many issues reported in v6.0.

Thanks and regards,
Bruce


#4

I’m using SQL Navigator 6.6 but still did not find an option to avoid my results are splitted.


#5

Hi Isabelle

SQL Navigator 5 is little different compared to 6.x, there is no way to see results without the split.
However we have a preference under View\Preferences\Code Editor\SQL Scripts called “Split Window to Display Results”

If you untick this option as I have in the screen shot you will get your results in subtab called Result 1.
You will have your original sql in the script subtab, and the data grid + sql in the Result 1 subtab, but it is maximized all the way up to the sql executed.

If you resize the grid it will be remembered until you restart the Code Editor or restart SQL Navigator.

hope this helps you
Lidia


#6

– TRACK SCRIPT APPLICATION HEADER BEGIN

SET

I tried this but it’s not like expected, or like given from TOAD product, where the spool is correctly created with the requested name as well.
Previously in Navigator 5, we needed to save the output with a defined own name.

SQL is :
**

DEFINE ON

COLUMN

db_name NEW_VALUE spoolfile

SELECT


SYS_CONTEXT(‘userenv’,‘db_name’) db_name from dual;

SPOOL

09632_001_RFC0000001234_SI2_testNavigator.sql_&spoolfile…log

SET

DEFINE OFF

SET

ECHO OFF HEAD OFF FEEDBACK OFF

BEGIN

pkg_bundles


.p_start_script(16837,‘testNavigator.sql’);

END


;

/

SELECT


pkg_bundles.f_get_log_info FROM dual;

SET

ECHO ON HEAD ON FEEDBACK ON

– TRACK SCRIPT APPLICATION HEADER END

select


sysdate from dual;

– TRACK SCRIPT APPLICATION FOOTER BEGIN

BEGIN


pkg_bundles.p_stop_script; END;

/

– END OF SCRIPT 09632_001_RFC0000001234_SI2_testNavigator.sql

– TRACK SCRIPT APPLICATION FOOTER END

SPOOL

**
OFF

SQL (= content script) + Result1

Result 2

Result 3

And on filesystem I have a file called 09632.lst

with content :

12765:16837:ABACBUDP

24-Jan-2013

On SCRIPT OUTPUT from Toad I have a file named 09632_001_RFC0000001234_SI2_testNavigator.sql_ABACBUDT.log with excpected content (to be used by an internal developed tool to load Logs of execution in a DB)

15772:16837:ABACBUDT

SQL> – TRACK SCRIPT APPLICATION HEADER END

SQL> select sysdate from dual

SYSDATE


24-JAN-13

1 row selected.

SQL> – TRACK SCRIPT APPLICATION FOOTER BEGIN

SQL> BEGIN pkg_bundles.p_stop_script; END;

PL/SQL procedure successfully completed.

SQL> – END OF SCRIPT 09632_001_RFC0000001234_SI2_testNavigator.sql

SQL> – TRACK SCRIPT APPLICATION FOOTER END

SQL> SPOOL OFF

Please advice. We don’t want to swith all users to TOAD as these licences are more expensive.


#7

SPOOL **OFF

Could you please try again and let us know how you go.

Thanks and regards,
Bruce**

SPOOL 09632_001_RFC0000001234_SI2_testNavigator.sql_&spoolfile…**log

SET ECHO OFF HEAD OFF FEEDBACK **OFF


COLUMN db_name NEW_VALUE spoolfile

Hi Isabelle,

We have tried and could get the file created with filename and the content of the spool in the output file, but we had to modified some lines of your script, ie have it on the same line as below: