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
2 answers

How to Parse Referral Links Using SQL

Hello StackOverflow world, I have a datasource that stores all of my website session data and I am hoping to analyze the referral URLS and group them into five categories: Home Site (www.mywebsite.com), Sub Site (www.mywebsite.com/employees),…
AnalyzeThis
  • 49
  • 6
0
votes
0 answers

Mysql Export in sql format with custom where condition

I have requirement in my project to extract the rows in sql format. I have multiple select statements with same WHERE condition. Is it possible to set the WHERE condition in a param and make use of it in the select statements? @set maxrows…
Srinivas Lakshman
  • 469
  • 2
  • 4
  • 21
0
votes
0 answers

How to connect to Cassandra within a docker container in order to view on DBVisualize on host machine?

I currently have a Docker container with Cassandra running within. I am trying to get a visual view using DBVisualizer of said Cassandra. I am using DataStax's Cassandra JDBC driver. I run my container like so: docker run --rm -it --net=host -p…
Jeffery Lee
  • 1
  • 1
0
votes
1 answer

Displaying three different columns from three Different Tables in SQL

I'm trying to display three different columns in SQL all from the same database but each from different tables. One is called Name which I would also like to have the output grouped by, another column is a calulation between two columns called…
user11681655
  • 23
  • 4
0
votes
1 answer

SQL Automatically rounding off variable

This is my code running on Vertica server on DB Visualizer. @echo ${Margin||77.5||decimal(5,2)||where noshow}$; When I run this line, I'm getting '77' as my value instead of '77.5'. select ${Margin}$ + 0 Could someone please tell me how to NOT…
fthedevs
  • 43
  • 1
  • 7
0
votes
0 answers

Is there a way to use a variable in a like statement in dbvisualizer

I need to compare 2 fields in dbvisualizer using the like operator. I keep getting a syntax error. Is it possible to do this? If so please advise on the syntax. Just a couple of the things I've tried unsuccessfully: //first where display_nm …
Nstone
  • 1
  • 1
0
votes
0 answers

MySql time differences, unexpected bahavior

The following behavior seems strange: select time_to_sec(timediff('00:00:00', '00:00:01')); -- -1 select timediff('00:00:00', '00:00:01'); -- 00:00:01 select time_to_sec('00:00:01'); -- 1 According to the MySql reference timediff returns arg1 -…
Christian
  • 1,308
  • 3
  • 14
  • 24
0
votes
0 answers

Using Filter in DB vis

A very 'beginner level' doubt but i couldnt find a similiar answer anywhere so i thought lets ask the experts. How do I copy and paste multiple values for comparison in the 'filter' section for a table in DB vis. Take this example As you can see i…
Uday
  • 31
  • 1
  • 9
0
votes
1 answer

DBVisualizer: how to increase fetch size?

I want to increase the fetch size in DbVisualizer on an Oracle DB. The standard fetch size is by 100 rows per time, not more, and this is not enough for very large amounts of data (for example during @export operations) because it needs too much…
Alessandro C
  • 3,310
  • 9
  • 46
  • 82
0
votes
0 answers

DB visualizer connection issues with the Hive thrift server (Query still running after completion) [HDP 2.6.x]

We are using DB visualizer to query Hive database on HDP 2.6.x, we are facing connection related issues with DB visualizer and hive. DB visualizer does not close the connection with Hive thrift server due to that jobs are always in running state in…
nilesh1212
  • 1,561
  • 2
  • 26
  • 60
0
votes
3 answers

Error DbVisualizer creating triggers

I am using the version of DbVisualizer Pro 9.5.6 and I am running the following sql command to create triggers. CREATE OR REPLACE TRIGGER "MYDB"."TG_T01_01" BEFORE INSERT ON T01 FOR EACH ROW BEGIN :NEW.FECALT_01 := SYSDATE; …
Alda
  • 9
  • 3
0
votes
1 answer

How to change the border color in DB-Visualizer?

I am using DB-Visualizer 9.2.10 and I want to change the border color of the editor but I don't see any border option to change. Below image shows the options colors and borders but in my pro version I don't see this option. Is there any other way…
David
  • 257
  • 1
  • 8
  • 24
0
votes
2 answers

How do I add extra rows to an Excel sheet via ODBC?

I used ODBC to create a sheet in Excel and add a row to it. Literally the commands were just: create table 'update5' ('age' NUMBER); insert into 'update5'.'age' values (1); This works and I can see the rows in the sheet and via DBVisualiser and my…
Stefan
  • 3,669
  • 2
  • 32
  • 43
0
votes
0 answers

DbVisualizer give error while connecting to hive with kerberos Authentication

I am trying to connect to hive using DBVisulizer. And I am following the article mentioned below https://github.com/timveil/hive-jdbc-uber-jar#kerberized-setup Following is my config file [libdefaults]   renew_lifetime = 7d   forwardable = true  …
Gaurang Shah
  • 11,764
  • 9
  • 74
  • 137
0
votes
1 answer

How to select a whole of clob column oracle?

I want to select a whole clob data without spisify to lenght of the return. this my request but with a limit lenght. select contentType,name, DBMS_LOB.substr(DATAS, dbms_lob.getlength(DATAS)) as doc from AutorisationDoc where AUTORIS_DOC =…
M.SAM SIM
  • 85
  • 1
  • 5
1 2 3
…
14 15