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?
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
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
I’m using SQL Navigator 6.6 but still did not find an option to avoid my results are splitted.
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
– 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.
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: