SQL Navigator Beta Program Community

SQL Navigator - Beta Forum

joethejet
Follow / 7 Feb 2018 at 5:08pm / SQL Navigator Beta Program
Latest post by on 8 Feb 2018 at 4:36pm

Is Nav Development Dead?

Expand content
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...

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.

91 2 / Create an account to join the discussion.
Sergey Smith
Follow / 18 Jan 2018 at 5:29am / SQL Navigator Beta Program
Latest post by on 8 Feb 2018 at 8:23am

HELP!!! Team Coding automated checkout

Expand content
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_config select * from toad...

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_config
select * from toad.tcx_team_projects

186 5 / Create an account to join the discussion.
OracleDBA
Follow / 6 Feb 2018 at 9:05pm / SQL Navigator Beta Program

oracle 12 c / sql nav 7.3 / can not extract ddl for tablespaces

Expand content
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_LOB 3:03:54...

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_LOB
3:03:54 PM ORA-01789: query block has incorrect number of result columns
3:03:54 PM Extract DDL complete
3:03:54 PM End Extract DDL for 1 object(s)

40 0 / Create an account to join the discussion.
OracleDBA
Follow / 6 Feb 2018 at 6:53pm / SQL Navigator Beta Program

sql nav 7.3 / oracle 12 c / lob table space

Expand content
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...

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_S
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 128K
NEXT 128K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
MONITORING;

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!! 

41 0 / Create an account to join the discussion.
michael
Follow / 6 Feb 2018 at 6:53am / SQL Navigator Beta Program
Latest post by on 6 Feb 2018 at 5:08pm

SQL Navigator 7.5 beta build 66 (expiring on 31/Mar/2018) is avai...

Expand content
Download Beta build expiring on 31-Mar-2018 Download Beta (64-bit) SQL Navigator Team

Download Beta build expiring on 31-Mar-2018

Download Beta (64-bit)

SQL Navigator Team

64 1 / Create an account to join the discussion.
alex.kloian
Follow / 11 Jul 2017 at 12:19pm / SQL Navigator Beta Program
Latest post by on 1 Feb 2018 at 8:24am

SQL Navigator beta expired

Expand content
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?

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?

1104 19 / Create an account to join the discussion.
Martin
Follow / 15 Nov 2017 at 7:28pm / SQL Navigator Beta Program
Latest post by on 23 Jan 2018 at 7:49am

Dot lookup for table columns not working in Nav 7.5.0.64

Expand content
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...

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:

Unanswered 239 2 / Create an account to join the discussion.
Sergey Smith
Follow / 16 Jan 2018 at 3:24am / SQL Navigator Beta Program
Latest post by on 23 Jan 2018 at 6:26am

How can i RESET verson controll cache

Expand content
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"

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"

Unanswered 167 3 / Create an account to join the discussion.
OracleDBA
Follow / 2 Jan 2018 at 8:18pm / SQL Navigator Beta Program
Latest post by on 4 Jan 2018 at 9:28am

ORA-14451: unsupported feature with temporary table

Expand content
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 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 ****
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

185 2 / Create an account to join the discussion.
Devender Karru
Follow / 2 May 2008 at 12:27am / SQL Navigator Beta Program
Latest post by on 10 Nov 2017 at 11:06am

Opening .sql file is a opening a new instance of SQL Navigator

Expand content
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...

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.

3559 2 / Create an account to join the discussion.
Sergey Smith
Follow / 19 Oct 2017 at 10:36am / SQL Navigator Beta Program

Ignore VCS Error "File {} is not checked out" on undo check...

Expand content
Conditions: 1.One VCS - many Oracle DB's 2. Same VCS User Steps: 1. Check-in object on First DB 2. Check-in object on Second DB 3. Check-out object on Second DB 4. Can't undo check-out...

Conditions:

1.One VCS - many Oracle DB's

2. Same VCS User

Steps:

1. Check-in object on First DB
2. Check-in object on Second DB
3. Check-out object on Second DB
4. Can't  undo check-out on First DB

What i see:

Object NOT undo check-out'ed
Output:
14:19:32 File $/FORP/FORPOST.SRL_REGPAYM.PBK is not checked out
14: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 out
2. Normal check-out state

185 0 / Create an account to join the discussion.
OracleDBA
Follow / 19 Sep 2017 at 9:37pm / SQL Navigator Beta Program

hidden character in text caused nav to not execute the where clause...

Expand content
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...


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. 

But

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 ****

UPDATE gpadmin.person   

   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. 

181 0 / Create an account to join the discussion.
OlafurTr
Follow / 18 Sep 2017 at 11:15am / SQL Navigator Beta Program

Object sys information incredibly slow

Expand content
Hi, 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...

Hi,

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

(Using SQLDBMon)

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..

Thanks.

Oli

185 0 / Create an account to join the discussion.
Kentlai
Follow / 9 Jan 2012 at 7:15am / SQL Navigator Beta Program
Latest post by on 24 Aug 2017 at 4:16am

SQL Navigator 6.6 installation error in Win7 64bit

Expand content
Please see the attached picture for the error case. 6.6.JPG sqlnav_6.6.0.2293.msi.zip
Please see the attached picture for the error case.

6.6.JPG

sqlnav_6.6.0.2293.msi.zip

4998 4 / Create an account to join the discussion.
joethejet
Follow / 24 May 2017 at 4:24pm / SQL Navigator Beta Program
Latest post by on 17 Aug 2017 at 7:50pm

Nav Dies Frequently

Expand content
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...

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.

596 3 / Create an account to join the discussion.
joethejet
Follow / 11 Jul 2017 at 8:33pm / SQL Navigator Beta Program
Latest post by on 3 Aug 2017 at 3:38pm

Formatting Question

Expand content
How do I get the label for a column on the same name as teh column in a select statement with the formatter? For example: SELECT 'one' FIRST, 'two' twoer, CASE WHEN ('y' ||...

How do I get the label for a column on the same name as teh column in a select statement with the formatter?

For example:

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

444 2 / Create an account to join the discussion.
joethejet
Follow / 2 Jun 2017 at 6:51pm / SQL Navigator Beta Program
Latest post by on 7 Jun 2017 at 8:37am

More formatting issues

Expand content
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"...

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. :(

690 3 / Create an account to join the discussion.
joethejet
Follow / 2 Jun 2017 at 6:05pm / SQL Navigator Beta Program
Latest post by on 6 Jun 2017 at 7:26pm

Loading Formatting .opt file doesn't work

Expand content
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...

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

496 2 / Create an account to join the discussion.
martin_goblet
Follow / 15 May 2017 at 2:04pm / SQL Navigator Beta Program
Latest post by on 24 May 2017 at 7:15am

Formatting issue with the aliases.

Expand content
Hi 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...

Hi

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="7.3.0.4148" 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>

Regards

Martin

661 3 / Create an account to join the discussion.
joethejet
Follow / 14 Apr 2017 at 6:35pm / SQL Navigator Beta Program
Latest post by on 16 May 2017 at 7:01pm

Setting Category doesn't Stick

Expand content
If I set a category on a connection in the project Manager and then try to open the connection, it doesn't keep the category in the popup logon window. If I have saved the password it does keep...

If I set a category on a connection in the project Manager and then try to open the connection, it doesn't keep the category in the popup logon window.

If I have saved the password it does keep it.

514 2 / Create an account to join the discussion.