Stack Overflow
Stack Overflow

Questions tagged [dbeaver]

DBeaver is a free and open-source (Apache License 2.0) universal database tool for developers and database administrators.

DBeaver is a free and open-source (Apache License 2.0) universal database tool for developers and database administrators.

  • Usability is the main goal of this project, program UI is carefully designed and implemented.
  • It is freeware.
  • It is multiplatform.
  • It is based on an open-source framework and allows the writing of various extensions (plugins).
  • It supports any database having a JDBC driver.
  • It may handle any external datasource which may or may not have a JDBC driver.
  • There is a set of plugins for certain databases and different database management utilities (e.g. ERD).
1047 questions
-1
votes
1 answer

Teradata Sql Assistant not showing text in the query result view

When I run a select query on an informix database using Teradata Sql Assistant all the text fields are null. But when I use another database manager like DBeaver, using a select query on the same table, I get values in the text fields. Has anyone…
titiu7
  • 101
  • 1
  • 4
-1
votes
1 answer

free gui tool to export and import data from and to relational databases

I'm searching free (as in freedom) GUI tools that allow me to export data from one relational database into files (CSV, XML, ...) and to bulk import this data into another database. Both database might be from different vendors. I'm already aware of…
Thomas Koch
  • 2,833
  • 2
  • 28
  • 36
-2
votes
1 answer

Debugging a SQL error in a SQL script line by line in DBeaver

I am using DBeaver 23.1.2. The following SQL script is failing with the following SQL error: SQL Error [1]: [SQLITE_ERROR] SQL error or missing database (near "type_id": syntax error) Is there a way to debug the following SQL script in DBeaver…
skeetastax
  • 1,016
  • 8
  • 18
-2
votes
1 answer

JSON column to columns in SQL

I have one dataset where one column is in JSON format. I want to transform it to several columns in SQL. I am using Postgres in DBeaver The JSON column is as below. I want to put everything that is inside abcde3 in several columns { …
Rods2292
  • 665
  • 2
  • 10
  • 28
-2
votes
1 answer

What is wrong with query, how do I correct the error?

INSERT ALL INTO ITDEV.COM_CATEGORY_TB (CAT_CODE,CAT_DESCRIPTION,CREATED_ON,CREATED_BY,UPDATED_ON,UPDATED_BY) VALUES (1001,'Cost Savings',TIMESTAMP'2010-12-14 00:00:00.0','SESH',NULL,NULL), (1002,'Business Improvements',TIMESTAMP'2010-12-14…
Misha Rukazo
  • 11
  • 4
-2
votes
1 answer

Sqlite Query Select Column Matching From Another Table

I have three tables with tbl_goods ,tbl_units and tbl_sat which looks like this : tbl_goods, consists of sold goods +--------+-------+-------+-------+ | goods |code |qty |unit | +--------+-------+-------+-------+ | cigar …
Imam
  • 37
  • 6
-2
votes
5 answers

Trying to get only cells with certain initials but giving me syntax error? SQL

So my assignment question is to "Get a list of all books withdrawn by people with the initials 'B.W.'. Show a column for the first name, last name, initials, and the title of the book". I am trying to join these 3 tables as it is the only way to get…
coder_underdog
  • 1
-2
votes
1 answer

MySQL Query improvement

I need to filter an DB, but my selection is too big for the DBeaver that i'm using. Is it possible to make it different? CustomersAffected IS NULL AND Node NOT LIKE 'CTA%' AND Node NOT LIKE 'OCO%' AND Node NOT LIKE 'SJC%' AND Node NOT LIKE…
André Santos
  • 3
  • 3
-2
votes
1 answer

can't install dbeaver on Virtual Machine following step based on link

I want to install dbeaver on virtual machine that using linux (maybe) following this step https://computingforgeeks.com/install-and-configure-dbeaver-on-ubuntu-debian/ i try to execute this code wget -O - https://dbeaver.io/debs/dbeaver.gpg.key |…
Handri Mauludin Maulana
  • 75
  • 1
  • 14
-3
votes
1 answer

How to create SQL table with columns from multiple tables

I have three tables in MySQL 'Customers', 'Deliverys_History'. The 'Customers' table has the customer ID and name information, while the 'Deliverys_History' table has the relationship of the orders placed by a customer, the status change date and…
Jailer Betancourt
  • 92
  • 9
-3
votes
3 answers

Incorrect syntax near ')'. SQL query is wrong while running on both DBeaver and on java mapper files?

DECLARE @source as NVARCHAR(MAX) = (SELECT md.[source] FROM sports_service.meet.meet_detail md WHERE md.meet_id = #{meetId}) WHERE reg.is_waitlist = 0 AND reg.cancelled_dt IS NULL AND NOT EXISTS ( SELECT 1 FROM…
Chiranjhivi Ghimire
  • 1,739
  • 1
  • 19
  • 21
1 2 3
…
69
70