You will no longer receive e-mail notifications from this forum.
Log-In to post
A new SQL Navigator beta is available with following changes:
SQLNAV-2201: fixed an error with Datafiles node in DB Navigator in a 12.2 database.
SQLNAV-2218: fixed an issue that double clicking to select text doesn't update the selection info in the status bar.
SQLNAV-2221, fixed an issue that reconnecting doesn't work for sessions Connect As SYS or SYSDBA.
Also, updated QP5 parser to v5.325.
Download Beta build 73 expiring on 31-May-2018
Download Beta (64-bit)
SQL Navigator Team
Download Beta build expiring on 31-Mar-2018
Sad to say it looks like it. We haven't seen anything since the last release and even the responses here are slow to come.
Despite the lip service to the contrary, I think the writing may be on the wall. I hate to see it because I think Nav is a superior product to TOAD or SQL Developer.
I just write a simple query:
SELECT p. FROM per_all_people_f p ORDER BY person_id DESC;
And when I rewrite the dot after "SELECT p" NAV just popups a tiny window with: <p.details> and some other options with <...> but not the table columns.
Ok, then I keep clicking on the <p.details> and nothing happens - the dotted line just gets longer:
Just encountered a problem with the formatting tool CTRL+R :
In version 7.4 beta, the aliases go on the next line. I copied my parameter from 7.3 to 7.4, but nothing changes.
Here my parameter file :
<SQLNavFormatter><SQLNavOptions Version="126.96.36.19948" Created="2015-12-02 09:31:08" Modified="2016-01-12 11:38:52"/> <QP5FormatterOptions><OptionsGUI>5.290.0</OptionsGUI> <Version>252</Version> <OutputTabs>2</OutputTabs> <IndentSize>2</IndentSize> <IndentTHENonSameLine>1</IndentTHENonSameLine> <IndentLOOPonSameLine>1</IndentLOOPonSameLine> <IndentISonSameLine>1</IndentISonSameLine> <RightMargin>128</RightMargin> <LF_LimitLinefeeds>0</LF_LimitLinefeeds> <VariableCase>2</VariableCase> <CommaStyle>2</CommaStyle> <ParensStyle>0</ParensStyle> <CaseAllowFlat>0</CaseAllowFlat> <DefaultArrangeOnCol>99</DefaultArrangeOnCol> <DefaultListParens>3</DefaultListParens> <CreateTableArrangement>D</CreateTableArrangement> <CreateTableListParens>6</CreateTableListParens> <CreateViewArrangement>D</CreateViewArrangement> <CreateViewListParens>6</CreateViewListParens> <RecordTypeArrangement>D</RecordTypeArrangement> <CreateTypeArrangement>D</CreateTypeArrangement> <CreateTypeListParens>6</CreateTypeListParens> <Tagline>0</Tagline> </QP5FormatterOptions></SQLNavFormatter>
Help! Help! Help!Team coding checks out objects automatically.in Pref. automate check out set to False
in Clob config in Team Coding in attach.txt:select * from toad.tcx_configselect * from toad.tcx_team_projects
We are not able to extract DDL for tablespaces on oracle 12c.
3:03:54 PM Executing Extract DDL ...3:03:54 PM Start Extract DDL for 1 object(s) ...3:03:54 PM Generating DDL for CLIENT_LOB3:03:54 PM ORA-01789: query block has incorrect number of result columns3:03:54 PM Extract DDL complete3:03:54 PM End Extract DDL for 1 object(s)
This is the extract ddl from toad for the same table.
CREATE TABLE SSADMIN.AWD_VOL_GPS_ENROLLMENT( PART_ID NUMBER(22) NOT NULL, AWD_LOG_ID NUMBER(22) NOT NULL, GROUP_NUM VARCHAR2(15 BYTE) NOT NULL, PLAN_NUM VARCHAR2(15 BYTE) NOT NULL, ENROLLMENT_DETAILS CLOB NOT NULL, CREATED_DATE DATE NOT NULL)LOB (ENROLLMENT_DETAILS) STORE AS SECUREFILE AWD_VOL_GPS_ENROLLMENT ( TABLESPACE DOCUMENT_STAGE_LOB ENABLE STORAGE IN ROW CHUNK 8192 COMPRESS HIGH NOCACHE LOGGING STORAGE ( INITIAL 8M NEXT 8M MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT ))TABLESPACE SSMT_DAT_SPCTUSED 0PCTFREE 10INITRANS 1MAXTRANS 255STORAGE ( INITIAL 128K NEXT 128K MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0 BUFFER_POOL DEFAULT )LOGGING NOCOMPRESS NOCACHEMONITORING;
CREATE TABLE SSADMIN.AWD_VOL_GPS_ENROLLMENT (PART_ID NUMBER(22,0) NOT NULL, AWD_LOG_ID NUMBER(22,0) NOT NULL, GROUP_NUM VARCHAR2(15) NOT NULL, PLAN_NUM VARCHAR2(15) NOT NULL, ENROLLMENT_DETAILS CLOB NOT NULL, CREATED_DATE DATE NOT NULL) SEGMENT CREATION IMMEDIATE TABLESPACE SSMT_DAT_S LOB ("ENROLLMENT_DETAILS") STORE AS SECUREFILE AWD_VOL_GPS_ENROLLMENT ( TABLESPACE SSMT_DAT_S NOCACHE LOGGING CHUNK 8192 ) NOPARALLEL LOGGING MONITORING/
The 2nd extract is from sql nav 7.3. For some reason sql nav did not extract the correct tablespace name for the lob. We store our lob datatypes on a specific tablespace and define that tablespace as a secure file. Toad 12 extracted the 12 c table correctly, sql nav did not.
DON'T LET THOSE TOAD GUYS GET AWAY WITH THIS!!
The last released SQL Navigator beta edition has expired.
Is there another one available for testing?
If so, can it be made available to us beta testers?
Because of BUGly VCS engine in SQL Navigator...
Please tell me how can i reset "in program" (sqlnav) state of vcs objects to state "new sql navigator open"
When you reverse the ddl on a global temporary table, sql nav throws in a default line, but that is not supported when you create a temp table.
SEGMENT CREATION IMMEDIATE. is not supported by Oracle when you create a temp table. The temp table does not have a segment..
**** SCRIPT STARTED Session: T54DB16@SSPQT.WORLD(2) 02-Jan-2018 14:08:36 ****CREATE GLOBAL TEMPORARY TABLE GPADMIN.PAYROLL_CALENDAR_TEMP (PAYROLL_DATE DATE, EFFECTIVE_DATE DATE, CUTOFF_DATE DATE, CC_FILE_DATE DATE, EXCLUDE_FLAG CHAR(1))ON COMMIT PRESERVE ROWS SEGMENT CREATION IMMEDIATE NOPARALLEL==>line 1: ORA-14451: unsupported feature with temporary table--------------------------------------------------------------------------------**** SCRIPT ENDED 02-Jan-2018 14:08:36 ****^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Hi, when double click on any .sql file, it is opening a new instance of SQL Navigator. I would like to change this option to open in the already opened existing session. Please let me know to change this option.
1.One VCS - many Oracle DB's
2. Same VCS User
1. Check-in object on First DB2. Check-in object on Second DB3. Check-out object on Second DB4. Can't undo check-out on First DB
What i see:
Object NOT undo check-out'edOutput:14:19:32 File $/FORP/FORPOST.SRL_REGPAYM.PBK is not checked out14:19:33 Error performing VCS undo check-out of: Operation aborted
What i expected:
1. log: 14:19:32 File $/FORP/FORPOST.SRL_REGPAYM.PBK is not checked out2. Normal check-out state
UPDATE gpadmin.person SET date_of_birth = TO_DATE ('04/07/1981', 'mm/dd/yyyy') WHERE person_idt = 2787057401;
not sure if your able to find the hidden text. We get update requests like this from development teams to update a specific record for a specific purpose. The data is copied and pasted into sql nav and executed by the dba team after management approvals This update executed without the where clause which updated all records in the table.
The spool reported that only 1 record was updated. Not all records.
**** SCRIPT STARTED Session: T54VS1U@ssprd.world(5) 05-Sep-2017 15:52:56 ****
SET date_of_birth = TO_DATE ('04/07/1981', 'mm/dd/yyyy')
WHERE person_idt = 2787057401
1 row(s) updated
**** SCRIPT ENDED 05-Sep-2017 15:52:56 ****
We have been able to duplicate this issue with sql nav 6.7 and 7.2. Please research. Please let me know if your able to find the hidden character that made nav skip the where clause.
I am having really bad timing issues in 7.3 that is also prevalent in the 7.4 betas.
Same schema, same database. I open a package from the sql window by typing the package name and press CTRL-Enter
SQL Navigator 6.7 (Old Quest version): Starting timestamp: 10:02:46 --> Last timestamp: 10:02:57 - Total lines 367
SQL Navigator 7.3 (new license): Starting timestamp: 10:02:55 --> Last timestamp: 10:04:44 - Total lines ~700
For me the new version is almost unusable since every now and then some background task will go and query the SYS objects and freeze the editor for a few minutes.
I have tried to enable/disable the option "Use user's dictionary views" but that doesn't fix/change anything.
This also applies to code completion that doesnðt work 80% of the time.
Anything I can do to speed this up? i.e I do not have access to the SYS user..
Anyone else having problems with Nav dying frequently? This started awhile back, but it has continued. Seems sort of random as I cannot figure out a pattern. Sometimes it dies while I'm doing something in Nav and sometimes I just come back and it's non-responsive.
Also in Windows 10, I almost always get a second "shadow" window that gets created on the task bar.
I have sent Vincent the sqlnavigator.el file from the incident that occurred yesterday.
How do I get the label for a column on the same name as teh column in a select statement with the formatter?
SELECT 'one' FIRST, 'two' twoer, CASE WHEN ('y' || 'n' || 't' || 'r' IN ('YYNN', 'NNYY', 'YYYY')) THEN 'Term' ELSE 'Active' END per_id_no,'three' third, '4' fourth FROM DUAL
will format as
SELECT 'one' FIRST, 'two' twoer, CASE WHEN ('y' || 'n' || 't' || 'r' IN ('YYNN', 'NNYY', 'YYYY')) THEN 'Term' ELSE 'Active' END per_id_no, 'three' third, '4' fourth FROM DUAL
Not sure what you guys did, but it's NOT formatting like it used to. Very frustrating to not change your settings but have it format different.
In addition, your positioning of "is/as" is broken. It will ALWAYS put on a new line. :(
If I try to load my old .opt file for formatting, it doesn't load or give me the option to save. Also, I believe that when I install a new version, it doesn't use my old formatting file. Shouldn't this carry over to the new version along with my preferences?
Also, why can't I resize the "Formatter Options" window?
It also appears that the "stacked on more than..." doesn't work