Stack Overflow
Stack Overflow

Questions tagged [dbvisualizer]

DBVisualizer is a popular database tool by DbVis Software AB. Written in Java, it runs on Windows, Mac OS X, and Unix/Linux, and will connect to any JDBC enabled database server.

DBVisualizer is a popular database tool by DBVis Software AB. Written in Java, it runs on Windows, Mac OSX, and Unix/Linux, and will connect to any database server.

214 questions
0
votes
0 answers

How to execute a procedure from SQL Commander which has refcursor as a out parameter in db-visulizer

I have checked many SO Answers pertaining to this topic, but couldn't get the correct answer which is DB-VISUALIZER centric.This is the start and end of my procedure in DB-VIZ CREATE OR REPLACE PROCEDURE "pivot_view"( res out sys_refcursor…
Scope
  • 727
  • 4
  • 15
0
votes
1 answer

How to resolve ORA-01489: result of string concatenation is too long

I have a table temp and Im trying to query as below : SELECT LISTAGG( 'MAX(CASE WHEN CATEGORY = '''||CATEGORY||''' THEN "'||"LEVEL"||'" END) AS "'|| "LEVEL"||'_'||CATEGORY||'"' , ',' ) WITHIN GROUP ( ORDER BY CATEGORY, "LEVEL" DESC …
Scope
  • 727
  • 4
  • 15
0
votes
0 answers

Run DB2 Query on Visual Studio with "|" in query?

I have DB2 query where inside I have to concacte with "|" to get the result. Here's the query : SELECT DISTINCT npkdcb, npkdps, npcob, npureg, npbktg, npblrg, …
Syafiqur__
  • 531
  • 7
  • 15
0
votes
1 answer

SQL query for date intervals comparing non-adjacent rows?

I want to flag the first date in every window of at least 31 days for each ID unit in my data. ROW ID INDEX_DATE 1 ABC 1/1/2019 2 ABC 1/7/2019 3 ABC 1/21/2019 4 ABC 2/2/2019 5 ABC 2/9/2019 6 ABC 3/6/2019 7 DEF …
Ezra
  • 21
  • 4
0
votes
0 answers

DBVisualizer not able to connect to Kerberised Hive

We have a HDP (3.1.0) cluster with Hive (3.0.0.3.1). The cluster is Kerberised; I am trying to connect to Hive with DBVisualizer, without success. The client (where I am using DBVisualizer from) is a Centos 7 Machine. Kerberos related On the…
Itération 122442
  • 2,644
  • 2
  • 27
  • 73
0
votes
2 answers

Auto increment with Trigger in oracle 11g : ORA-00900: invalid SQL statement [Script position: 363 - 367] END

I wanna create a Table with auto increment the id in oracle 11g in dbvisualizer, I know that in oracle 12c Identity is there for this but in 11g I followed the below scenario and facing issue. CREATE TABLE sample ( id NUMBER NOT NULL, …
Vinay Kumar
  • 1,199
  • 13
  • 16
0
votes
1 answer

How to read in multiple JSON files from a folder in SQL without using Bulk

I am trying to read in multiple JSON files in SQL. I do not have Bulk Permissions and am using DbVisualizer. I currently have to copy and paste each file. Is there a way to read in over 400 files with different names. Declare @json nvarchar(Max) Set…
Pfwangs
  • 41
  • 5
0
votes
0 answers

Cannot connect to MS Access using UCanAccess

I'm using DbVisualizer Free 11.0 [Build #3077] OS: Windows 10 OS Arch: amd64 Java Version: 1.8.0_242 Java VM: OpenJDK 64-Bit Server VM Trying to create UCanAccess driver using the following…
Dennis S.
  • 47
  • 7
0
votes
2 answers

get only one value for customer_ID where multiple rows for where

Hi all this is my query - if I run this I get multiple customer ids but I just want to select one customer id SELECT payments.customer_id, payments.reason, payments.date FROM payments WHERE reason like '%error%' ORDER BY…
anca
  • 19
  • 4
0
votes
1 answer

Issue in using cursor with parameters

I am using a cursor with both input and output parameters to fetch data from a select query and insert into another table at intervals:- DECLARE i_start_date varchar2(20) := '2019-01-02'; i_end_date varchar2(20):= '2019-01-09'; v_ack_records…
RLearner
  • 65
  • 5
0
votes
1 answer

DbVisualizer - duplicate links on References tab

Any ideea why DbVisualizer 10.0.25 x64 (Win10) shows duplicate fks? If I run this query SELECT tc.table_schema, tc.constraint_name, tc.table_name, kcu.column_name, ccu.table_schema AS foreign_table_schema, ccu.table_name…
Liviu A.
  • 25
  • 4
0
votes
3 answers

DBVis/PL SQL: IF EXIST - how to structure correctly if possible

Using the DBVis SQL commander (as I am using "begin" and "end" in this code, I believe this code is executing in a PL SQL manner) I am trying to execute an sql script I have written to be my new "cleaning trigger" I am trying to use IF EXISTS…
George c
  • 65
  • 1
  • 9
0
votes
1 answer

Full word cursor movement in DBVisualizer script editor

I have been unable to find how to do full-word cursor movement in the DBVisualizer script editor. The normal macos commands of ctl-[left/right]arrow and Option-[left/right]arrow do not work. The Command-[left/right]arrow does something different:…
WestCoastProjects
  • 58,982
  • 91
  • 316
  • 560
0
votes
2 answers

how to solve db2 code: -104, SQL State: 42601

--/ BEGIN FOR V AS MYCURSOR CURSOR FOR SELECT ID,NAME,AGE FROM PEOPLE DO BEGIN INSERT INTO PERSON(NAME,AGE) VALUES(V.NAME,V.AGE); END; END FOR; END; / DB tool is Dbvisualizer 10.0.1, so I need "--/" and…
Jens
  • 1
  • 1
  • 1
0
votes
0 answers

Can't see table columns DbVisualizer Graph PostgreSQL

I'm trying to make a graph with all the TABLES/VIEWS that I want : pg_authid, pg_group, pg_roles, pg_auth_members, pg_namespace, pg_shadow, pg_user. So as you can see it only works for TABLES columns pg_authid, pg_auth_members, pg_namespace. But not…
Hashka
  • 395
  • 3
  • 10
1 2 3
…
14 15