You will no longer receive e-mail notifications from this forum.
Log-In to post
Do you have a quick support question and short of time? Contact us Via Twitter @QuestExperts and we will take care of you. #Jointheinnovation #WeareQuest
I have installed Oracle client 11g (not instant) with administrator option in Windows 10. The oracle installation was successful, however when I tried launching SQL Navigator, it threw me an error that it could not find Oracle client.
Please see the attached screenshots.
I'm using Toad 12.10 and Oracle 11 64 bits. I've a package of stored procedure and when I execute a procedure that returns a sys_refcursor nothing is displayed as shown below
Note that I've shoosen to display results in a grid as indicated below
Can anyone tell me were I'm wrong and how to resolve this problem.
In preferences, there is a parameter for the table alias :
I would like to have the real table name as alias, not "a" or another letter. I tried to remove the "a", but it always comes back. Is this possible ?
I'm running a big SQL statement with absolutely no updates. Why does the session manager show bloc_changes / consistent_changes on this statement :
I am new to sql navigator and trying to connect it to GitHub.
as per https://bradwulf.wordpress.c
om/2016/06/06/sql-navigator-team-coding-with-git/ , it should provide panel to select git project. Please revert with help if I am missing anything.
I have just started using SQL Navigator 7.1. I am used using SQL developer 4.0. In SQL developer 4 I am able to click VIEW>Data Modeler>CLICK BROWSER for Browser pane,>within the pane expand designs>right click relational models>new relational models once a pane is open for the relation model I can drag and drop specific tables to create a relational model. . Can someone please direct me on how to do this in SQL Navigator 7.1.0
Can someone give an overview of the difference between 5.5 and the current version and the benefit of upgrading?
Also, what advantages does it offer over SQL Developer?
I often execute scripts, and during the execution time I work an other one. With the last versions it's nearly impossible. SQL Nav only opens the other tabs when the execution is finished.
Example : I ran the forth tab and wanted to work on the first one : that's what I get. The first tab will open when the execution of the fourth tab is finished (in this case in 2 hours !)
SQL Navigator 220.127.116.1194
Windows 10 Enterprise 64-bit Version 1511
I have multiple displays,two external monitors and the laptop display, and have encountered a variety of window/panel display problems. The problems occur when shutdown in hibernate mode and reopen on a different multiple monitor environment (same number of displays) Most frequently, SQL Nav windows end up located outside the edges of the physical displays and have to be manually moved into the physical display space. Less frequently, the layering and position of modal dialogs is behind the window from which the dialog was initiated from and, again, have to be manually relocated from behind the main window.
I have code expert on my sql nav. How do I write rules so I can use code expert to help me with my pl / sql code reviews?
We are using Windows 10, Oracle 12c 32x Client, and SQL Nav 7.3 32x.
One of Oracle DBA cannot query which added a new column on table, he have to restart SQL/Nav, then work.
Is there any suggestion?
(FYI.. my machine is working fine.)
When I do a refresh (F5 or play button) in a Compare, SQL Nav >= 7.3 v 32 bit crashes :
When I run a SELECT with a related database (@...), I'm not able to stop this one. It still runs to the end.
Right clic on Constraints tab + New : I expected to create a new contraint, but I get the "New table" screen. Same with the other tabs index and triggers, ...
Could it be possible to associate the right clic with the tab, like it does in the middle of the window :
I would like to clean out the default databases it is loading in SQL Navigator 6.7.
I tried regedit and tried to find the directory it was loaded to but couldn't find it. I just want to kill off the list of databases loaded at startup so it is kind of clean (for instance kill the local settings so it is like a clean install for instance).
All versions i tested so far 6.2, 6.7, 7.2 (Trial) have same problem.
When i trying to use EXPLAIN_PLAN the Plan tree not displaying,
The data still appear into table SYS.PLAN_TABLE$
Is there anything with configuration ? Any option to fix?
Thank you in advance.
I see following issues, when working with the trigger editor:
- if trigger properties is pinned and trigger text is greater then the editor text, navigating down with the mouse navigates outside of the editor
- formatting of compound trigger does not work
- auto code completion for :new and :old values does not work
I need to optimise an awful statement I got :
SELECT /*+FIRST_ROWS ordered*/ fcmx1.key_p ,fcmx1.cent ,DECODE(fcmx1.dpce, 0, '', TO_CHAR(TO_DATE(LPAD(fcmx1.dpce, 8, '0'), 'YYYYMMDD'), 'DD/MM/YYYY')) AS dpce ,fcmx1.cjnl ,fcmx1.npce AS npce ,DECODE(fcmx1.csens, 'C', -1 * fcmx1.mmvt, fcmx1.mmvt) AS mmvt ,fcmx1.csens ,fcmx1.mreste ,fcmx1.mreste_ml1 ,fcmx1.ccx AS ccx_orig ,DECODE(fcmx1.dech, 0, '', TO_CHAR(TO_DATE(fcmx1.dech, 'YYYYMMDD'), 'DD/MM/YYYY')) AS dech ,fcmx1.nseq_jnl AS let_nseq_jnl ,fcmx1.ntrans AS let_ntrans ,fcmx1.nseq_trans AS let_nseq_trans ,fcmx1.nseq_ech AS let_nseq_ech ,fcmx1.ctrans_ext ,fcmx1.cdev ,fcmx1.lref ,DECODE(NVL(z_sele.iden, ' '), '56de7bf06cc87__U49415', 'true', 'false') selec ,DECODE(fcmx1.opmt_encrs, NULL, '#FFFFFF', '#FF8080') AS bgcolor ,DECODE(fcmx1.opmt_encrs, NULL, '', 'logo_warning') AS logo_warning ,DECODE(fcmx1.opmt_encrs, NULL, '', 'Optn paiement en cours') AS warning_value FROM (SELECT fc083.cent_ass FROM TABLE(zac_f_param2('282', 'FC083', '3562' || '%')) param_fc083, fc083, fc014 WHERE fc083.key_p LIKE param_fc083.key_p AND fc014.cent = fc083.cent_ass AND fc014.cent_ass = '282' UNION SELECT '282' AS cent_ass FROM DUAL) table_cent_ass ,TABLE(zac_f_hierarchie(table_cent_ass.cent_ass)) hierar ,TABLE(zac_f_param2('282', 'FC191', 'FOUD')) param_fc191 ,fc191 ,fcmx1 ,z_sele ,((SELECT DISTINCT fc081.cjnl FROM TABLE(zac_f_hierarchie('282')) hierar, TABLE(zac_f_param2(hierar.entite, 'FC081', '%')) param_fc081, fc081 WHERE fc081.key_p LIKE param_fc081.key_p)) cjnl_in WHERE fc191.key_p LIKE param_fc191.key_p AND fcmx1.key_c LIKE 'CMX11' || RPAD(hierar.entite, 4) || 'AUX' || DECODE(fc191.tmod, '3', 'D', '4', 'C', '_') || RPAD('FOUD', 4) || RPAD('015093990000', 15) || '%' AND fcmx1.cdev LIKE 'EUR' AND fcmx1.cjnl LIKE cjnl_in.cjnl AND (fcmx1.npce BETWEEN 8590257 AND 85902761) AND fcmx1.key_p = z_sele.key_p AND z_sele.iden = '56de7bf06cc87__U49415'ORDER BY fcmx1.cent, fcmx1.dpce, fcmx1.npce
The problem is that when I launch the Explain Plan I directly get the error OCI-22053:overflow error
Why is the selection of the columns disabled when exporting data's from selected rows ?