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?
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.
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,
I’m using SQL Navigator 6.6 but still did not find an option to avoid my results are splitted.
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
– TRACK SCRIPT APPLICATION HEADER BEGIN
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 :
db_name NEW_VALUE spoolfile
SYS_CONTEXT(‘userenv’,‘db_name’) db_name from dual;
ECHO OFF HEAD OFF FEEDBACK OFF
pkg_bundles.f_get_log_info FROM dual;
ECHO ON HEAD ON FEEDBACK ON
– TRACK SCRIPT APPLICATION HEADER END
sysdate from dual;
– TRACK SCRIPT APPLICATION FOOTER BEGIN
– END OF SCRIPT 09632_001_RFC0000001234_SI2_testNavigator.sql
– TRACK SCRIPT APPLICATION FOOTER END
SQL (= content script) + Result1
And on filesystem I have a file called 09632.lst
with content :
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)
SQL> – TRACK SCRIPT APPLICATION HEADER END
SQL> select sysdate from dual
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.
Could you please try again and let us know how you go.
Thanks and regards,
SET ECHO OFF HEAD OFF FEEDBACK **OFF
COLUMN db_name NEW_VALUE spoolfile
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: