SQL Navigator Forum

james.q.zhu
Follow / 7 Feb 2018 at 7:55am / SQL Navigator
Latest post by on 11 Feb 2018 at 5:59am

SQL Navigator 7.4 cann't commit to SVN

Expand content
problem desc: 1、 do 'check out' a package 2、SQL Navigator generate 2 files for this package 3、do 'Check in' 4、you can find SQL Navigator exeute svn 'add' command but not...

problem desc:

1、 do  'check out'  a package

2、SQL Navigator generate 2 files for this package

3、do 'Check in'

4、you can find SQL Navigator exeute svn 'add'  command but not execute 'commit '  command  

so the two package files cann't find in SVN Server. 

anyone know this issue?

Production Version: SQL Navigator 2017 Trial Edition(SQL Navigator 7.4 Trial)

347 4 / Create an account to join the discussion.
drastogi
Follow / 29 Jan 2018 at 3:26pm / SQL Navigator
Latest post by on 30 Jan 2018 at 5:38pm

SQLNAV 7.4 64-Bit Random crash

Expand content
SQL Navigator 7.4 64-bit on Windows Enterprise 10 64-bit is crashing with the following error: Control 'dpCodeAssistant' has no parent window. Has anyone seen this error or has a suggestion...

SQL Navigator 7.4 64-bit on Windows Enterprise 10 64-bit is crashing with the following error:

Control 'dpCodeAssistant' has no parent window. 

Has anyone seen this error or has a suggestion to resolve? Thanks. 

437 2 / Create an account to join the discussion.
Vincent Liu
Follow / 17 Aug 2016 at 7:53am / SQL Navigator
Latest post by on 29 Jan 2018 at 12:35pm

SQL Navigator 7.3 is released

Expand content
Dear all, We are very pleased to announce that SQL Navigator version 7.3 has been released. Thank you all for supporting the product and we really appreciate feedbacks and suggestions from you. New...

Dear all,

We are very pleased to announce that SQL Navigator version 7.3 has been released. Thank you all for supporting the product and we really appreciate feedbacks and suggestions from you.

New features in SQL Navigator 7.3:

  • Connection Category Color - Optionally assign a connection to a category color in the Oracle Logon Dialog. Possible categories could be: development, test or production. You could create your own categories and assign colors as appropriate. The color is displayed in the following places in SQL Navigator: the connection entry in the Session toolbar, the border of windows belonging to the connection, task bar icons of windows belonging to the connection and tab icons of the Code Editor window.

  • New Online Search Dialog - When you double click on an error message which contains an Oracle error code, you can now select the online search engine to use to receive detailed Oracle error information from. Options include Google, Online Knowledge Base (maintained by Dell Support), Online Knowledge Xpert (maintained as Toad World Wiki) and Toad World Search.

  • Team Coding - The settings and backend repository are now compatible with Toad for Oracle 12.7. Git is now a supported Version Control System. There are new interfaces to administer Team Coding and manage Team Coding Objects.

  • Windows 10 - Support for Windows 10

     

The complete list of resolved issues and enhancements (for 7.3 release):
http://www.toadworld.com/products/sql-navigator/w/wiki/10945.sql-navigator-resolved-issues-and-enhancements.aspx

Product documentation:
https://support.quest.com/sql-navigator-for-oracle/release-notes-guides 

Download the newest release (upgrade for existing users):
https://support.quest.com/sql-navigator-for-oracle/download-new-releases 

Download trial of the latest release (free trial for new users):
https://www.quest.com/registert/54629/ 

Regards,

SQL Navigator Team

3796 2 / Create an account to join the discussion.
krmckee
Follow / 24 Jan 2018 at 1:47pm / SQL Navigator
Latest post by on 29 Jan 2018 at 6:17am

How to start using SQL Navigator and SVN/Subversion

Expand content
Hi - I recently downloaded a trial of SQL Navigator 7.4 and am trying to integrate it with my SVN server. Here's what I've done so far I connected to one of my databases, then I went to the Team...

Hi - I recently downloaded a trial of SQL Navigator 7.4 and am trying to integrate it with my SVN server.  Here's what I've done so far

I connected to one of my databases, then I went to the Team Coding menu and selected Team Coding Manager

I went to the VCS tab, right clicked and chose Configure

I specified the following options for SVN

(Servername blanked for security reasons, but my server name is in the settings)

I then went back to the Team Coding menu and chose Provider Logon

where it prompted me for my username/password, and then it shows

so I believe I'm connecting to my SVN server fine.

Now what I want to be able to do is take all of my database elements (table DDL, functions, stored procedures, etc) and check them all into SVN so that I can start doing version control.  This is where I get stuck, as there doesn't seem to be any way to do this?  Are my expectations wrong, or am I just missing something?  Any help would be greatly appreciated.

Thanks

575 1 / Create an account to join the discussion.
virajdodanwala
Follow / 25 Jan 2018 at 12:53pm / SQL Navigator

SQL Navigator 7.4 - Team Coding - Error when try to compare changes...

Expand content
Dears, I am new to this GIT version controlling system and i am trying to use SQL Navigator 7.4 with GIT version controlling system to maintain DB changes. Initial configuration i have done and changes...

Dears, 

I am new to this GIT version controlling system and i am trying to use SQL Navigator 7.4 with GIT version controlling system to maintain DB changes.

Initial configuration i have done and changes are properly pushing to Bitbucket also. But when i try to compare the change of the Database object ( ex: Table change) with the VCS through SQL navigator

( Menu path is Team Coding -> Team Coding Manager . Then expand the DB object and right click on the Table -> Compare Content)

When i select to compare . its giving below error message.

If anyone can help/ Guide to fix this, it would be great.

Unanswered 346 0 / Create an account to join the discussion.
Fsilva
Follow / 7 Sep 2009 at 2:19pm / SQL Navigator
Latest post by on 22 Dec 2017 at 4:07pm

Bookmarks and formatter

Expand content
Hi Is there any way to keep the bookmarks between formating (it cleans the bookmarks even if the line didn't changed)? thanks Filipe

Hi

Is there any way to keep the bookmarks between formating (it cleans the bookmarks even if the line didn't changed)?

thanks

Filipe

5139 4 / Create an account to join the discussion.
martin_goblet
Follow / 2 Nov 2017 at 8:07am / SQL Navigator
Latest post by on 24 Nov 2017 at 8:32am

Error is not more shown (7.3 32 bit, Win 7 64 pro)

Expand content
Hi I just tried to delete a table an forgot that there is a delete cascade on it. instead of getting the error, I got this : Regards Martin

Hi

I just tried to delete a table an forgot that there is a delete cascade on it.  instead of getting the error, I got this :

Regards

Martin

985 2 / Create an account to join the discussion.
martin_goblet
Follow / 15 Nov 2017 at 9:43am / SQL Navigator
Latest post by on 23 Nov 2017 at 2:49am

Crash when closing a session (7.3 32 bit, Win 7 64 pro)

Expand content
Hi Sometimes SQL NAv crashes when I close a session : Log files : SQL Navigator 7.3.0.zip Regards Martin

Hi

Sometimes SQL NAv crashes when I close a session :

Log files :

SQL Navigator 7.3.0.zip

Regards

Martin

1080 1 / Create an account to join the discussion.
Bill
Follow / 14 Nov 2017 at 6:49pm / SQL Navigator
Latest post by on 20 Nov 2017 at 1:12pm

Insert or Update if exists from a staging table to another table

Expand content
Hello I have a process that runs daily that pulls down a csv file imports it and does some conversion and puts that converted data into a staging table. I then want a plsql script I can automate...

Hello

I have a process that runs daily that pulls down a csv file imports it and does some conversion and puts that converted data into a staging table. 

I then want a plsql script I can automate along with the other process to insert or update the data from the Staging Table to the main table.

I will have several hundred thousand records per day and approximately 25% of them will be data that needs to be updated.

Example

Maintable Contains

COOPID,ACCOUNTID,DATETIME,VALUE
HSCE,300001,9/10/2017 5:00:00.0000000 AM,0.48
HSCE,300001,9/10/2017 6:00:00.0000000 AM,5
HSCE,300001,9/10/2017 7:00:00.0000000 AM,1
HSCE,300001,9/10/2017 8:00:00.0000000 AM,2.3
HSCE,300001,9/10/2017 9:00:00.0000000 AM,1.8
HSCE,300001,9/10/2017 10:00:00.0000000 AM,3
HSCE,300001,9/10/2017 11:00:00.0000000 AM,2.3

StagingTable Contains

COOPID,ACCOUNTID,DATETIME,VALUE
HSCE,300001,9/10/2017 5:00:00.0000000 AM,3.8
HSCE,300001,9/10/2017 6:00:00.0000000 AM,2.6
HSCE,300001,9/10/2017 7:00:00.0000000 AM,1.2
HSCE,300001,9/11/2017 8:00:00.0000000 AM,6.2
HSCE,300001,9/11/2017 9:00:00.0000000 AM,3.3
HSCE,300001,9/11/2017 10:00:00.0000000 AM,2.5
HSCE,300001,9/11/2017 11:00:00.0000000 AM,6.6

I want a script that will automatically put in the new 9/11 data into the MainTable and update the MainTable with the new values for 9/10 This is a small size example for 1 account but the file and table both contain lots of accounts for many years worth of data.

I looked at Merge and other postings however all seem to use Dual instead of looking at 2 tables.

Thanks for the help

1427 6 / Create an account to join the discussion.
Reise
Follow / 23 Oct 2017 at 10:44am / SQL Navigator
Latest post by on 7 Nov 2017 at 9:54am

Formmater issue with ANSI SQL

Expand content
I'm troubling making the formmater align keywords in ANSI SQL. In the higlight part the join and on keyword should be aligned with the from I want to make it like this Any help is great...

I'm troubling making the formmater align keywords in ANSI SQL.

In the higlight part the join and on keyword should be aligned with the from

I want to make it like this

Any help is great...

Unanswered 1093 2 / Create an account to join the discussion.
martin_goblet
Follow / 8 Sep 2016 at 9:43am / SQL Navigator
Latest post by on 31 Oct 2017 at 6:10am

Statement still executes, even after a STOP !

Expand content
Hi When I run a SELECT with a related database (@...), I'm not able to stop this one. It still runs to the end. Regards Martin

Hi

When I run a SELECT with a related database (@...), I'm not able to stop this one.  It still runs to the end.

Regards

Martin

2679 9 / Create an account to join the discussion.
chdodso
Follow / 19 Oct 2017 at 2:40pm / SQL Navigator

Extract DDL Missing ;

Expand content
We've just upgraded to SQL Navigator 7.3 (7.3.0.4294) I extract the DDL for a view to include the grants. When I try to run the script I get ORA-00933: SQL command not properly ended. Troubleshooting...

We've just upgraded to SQL Navigator 7.3 (7.3.0.4294)

I extract the DDL for a view to include the grants.  When I try to run the script I get ORA-00933: SQL command not properly ended.

Troubleshooting show that I either have to take all the grant clauses out of the script or put an ";" at the end of the view creation portion manually.

645 0 / Create an account to join the discussion.
ashmelev
Follow / 18 Oct 2017 at 6:18pm / SQL Navigator

Unable create a view using Oracle 12c features

Expand content
Here'a sample query I've created that uses WITH clause with a function and some sub-query (my real query is much more complex, but has similar structure). --CREATE VIEW TMP_ABC AS WITH FUNCTION...

Here'a sample query I've created that uses WITH clause with a function and some sub-query (my real query is much more complex, but has similar structure).

--CREATE VIEW TMP_ABC AS

WITH
FUNCTION abc (p_val NUMBER) RETURN VARCHAR2 IS
vret VARCHAR2 (100);
BEGIN
SELECT LPAD (' ', p_val, 'z') INTO vret FROM DUAL;

RETURN vret;
END;
gen AS (SELECT ROWNUM rn FROM DUAL CONNECT BY LEVEL < 10)
SELECT gen.rn, abc (rn) abc
FROM gen;

With the first line commented out, the query runs fine from SQL Navigator 7.4, formatter is able to format it, but if I uncomment the first line and attempt to create a view based on this query I get an error message.

line 1: ORA-06553: PLS-103: Encountered the symbol "end-of-file" when expecting one of the following:

:= ; not null default character

or

line 12: ORA-00900: invalid SQL statement

Using SQL Nav 7.4 64-bit, Oracle 12c client 64 bit and 12c database.

Tried Oracle SQL Developer and the view creation script works just fine.

525 0 / Create an account to join the discussion.
saman
Follow / 10 Nov 2012 at 1:31am / SQL Navigator
Latest post by on 3 Oct 2017 at 6:14am

i need a key authorization for sqlnavigator 6.7

Expand content
I downloaded a trial version of sqlnavigator 6.7 , they sent me a mail with license key but it was expired. Please can anybody help me??? Thanks Saman

I downloaded a trial version of sqlnavigator 6.7 , they sent me a mail with license key but it was expired. Please can anybody help me???
Thanks
Saman

9491 7 / Create an account to join the discussion.
Reise
Follow / 28 Sep 2017 at 2:57pm / SQL Navigator
Latest post by on 2 Oct 2017 at 10:52am

Formmater options to not stack parameters in internal functions?

Expand content
Is there an option on formmatter options to prevent the parameters of internal functions to go the the next line and get stacked? I'm using SQL Navigator 7.3.0.4294 This is what I get: This...

Is there an option on formmatter options to prevent the parameters of internal functions to go the the next line and get stacked?

I'm using SQL Navigator 7.3.0.4294

This is what I get:

This is what I wanted:

SELECT NVL (SUBSTR (RTRIM (a3.VALUE), 1, 25), 'n/a')

1165 2 / Create an account to join the discussion.
martin_goblet
Follow / 22 Sep 2017 at 9:32am / SQL Navigator
Latest post by on 30 Sep 2017 at 10:25am

Crash when inserting a new record in a table

Expand content
Hi Version :V 7.3.0.4294 32bit, win 7 pro 64 bit. When I select * from a table and want to add a record with the (+) signe, SQL Nav crashes Regards Martin

Hi

Version  :V 7.3.0.4294 32bit, win 7 pro 64 bit.

When I select * from a table and want to add a record with the (+) signe, SQL Nav crashes

Regards

Martin

1212 3 / Create an account to join the discussion.
andreml
Follow / 31 Aug 2017 at 6:14pm / SQL Navigator
Latest post by on 19 Sep 2017 at 7:04am

Problem with latest SQL Navi GA (64bit) regarding VARCHAR2(32767)...

Expand content
Hi, today I noticed the there is an issue in data grid: a) when a col ist defines as VARCHAR2(32767) means gt 4000 b) when you query External Table with CLOB colums, the CLOB output in data grid...

Hi,

today I noticed the there is an issue in data grid:

a) when a col ist defines as VARCHAR2(32767)  means gt 4000

b) when you query External Table with CLOB colums, the CLOB output in data grid returns soem quirk 

Can some verify this please?

Thank you and best Regards

Andre

3483 4 / Create an account to join the discussion.
Nate.Gaffaney
Follow / 14 Sep 2017 at 12:19pm / SQL Navigator

Re: 答复: [SQL Navigator - Discussion Forum] Problem with latest SQL...

Expand content
Hi Michael, I assume what he is referring to as the strange e-mails is the “badge” system where by asking a question he earned an achievement. New achievements earned do result in an automated e...
Hi Michael,
 
I assume what he is referring to as the strange e-mails is the “badge” system where by asking a question he earned an achievement.  New achievements earned do result in an automated e-mail being sent with congratulations for the new achievement earned.  Sometimes they have whimsical names or text associated with them.  He can see which achievements he’s earned by visiting his profile: http://www.toadworld.com/members/andreml 
 
This isn’t new and has been around for a while.
 
Regards,
 

-          Nate

 
From: "Michael Luo (mluo)" <Michael.Luo@quest.com>
Date: Thursday, September 14, 2017 at 1:38 AM
To: "sqlnav@toadworld.com" <sqlnav@toadworld.com>, "QDL.ToadWorldAdmins" <QDL.ToadWorldAdmins@quest.com>
Cc: "Vincent Liu (vliu)" <Vincent.Liu@quest.com>
Subject:
答复: [SQL Navigator - Discussion Forum] Problem with latest SQL Navi GA (64bit) regarding VARCHAR2(32767) and External Table with CLOB colums
 
Hi admin,
 
Customer complain that community send him some strange mails in the background.
 
Is there any changes for community of ToadWorld?
 
Regards,
Michael
 
发件人: andreml [mailto:bounce-andreml@toadworld.com]
发送时间: Saturday, September 09, 2017 9:52 PM
收件人: sqlnav@toadworld.com
主题: RE: [SQL Navigator - Discussion Forum] Problem with latest SQL Navi GA (64bit) regarding VARCHAR2(32767) and External Table with CLOB colums
 
Reply by andreml

Hi,
Well, even when I got some strange mails (telling me how great my question is and what a cool guy I am.) - no useful answer at all.
So, friends - what’s the matter here.

I do hope, this is forum with more than a "artificial intelligence"-mailing system in the background.
Regards
Andre

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from SQL Navigator Forum notifications altogether.
SQL Navigator - Discussion Forum

Flag this post as spam/abuse.

585 0 / Create an account to join the discussion.
martin_goblet
Follow / 3 Aug 2017 at 3:15pm / SQL Navigator
Latest post by on 6 Sep 2017 at 6:10am

Control + clic on a package procedure doesn't go to the right...

Expand content
Hi I'm in V7.3 32bit, Win 7 64 bit pro. When I do a control click on a package procedure like this one : it just opens the package body and does not go to the procedure like before. Regards...

Hi

I'm in V7.3 32bit, Win 7 64 bit pro.  When I do a control click on a package procedure like this one :

it just opens the package body and does not go to the procedure like before.

Regards

Martin

1127 1 / Create an account to join the discussion.
martin_goblet
Follow / 7 Jun 2017 at 1:09pm / SQL Navigator
Latest post by on 21 Aug 2017 at 2:43pm

SQL Nav 7.3 32 bit forgets the saved name

Expand content
Hi I'm working on a large SQL statement and I save this one regularly. Each time he asks me to give a name, even if the file has already a name. Regards Martin

Hi

I'm working on a large SQL statement and I save this one regularly.  Each time he asks me to give a name, even if the file has already a name.

Regards

Martin

1480 3 / Create an account to join the discussion.