DBeaver adds a character (the first letter of the table name) when auto completing table names, resulting in a query that looks like this: As far as i can tell, it works, and has no impact on the query/results… can anyone enlighten me as to what it (the c) is? Answer “C” is an alias name of …
Tag: dbeaver
Can’t execute a while clause in SQL Server with Dbeaver
I am trying to execute a loop while in Dbeaver with SQL Server, but the statement keeps loading and does not execute it. I just want to print the word ‘ok!’ 3 times. I’m not sure if it’s a loop problem, a Dbeaver problem, or another. Can anyone help please? My code: Screenshot from Dbe…
PostgreSQL: Using CTE with IN
Learning CTE right now, the following query is super basic and it doesn’t really have any useful value but I don’t understand why it doesn’t work The error I’m getting is “ERROR: column “cte_actors” does not exist” Currently using postgres 14 and DBeaver Answer …
Remove schema name from DBeaver’s query
I am new to DBeaver and I am using it for the postgres client. I was using Navicat before and in navicat the query simply used to run without schema name as SELECT * FROM TABLE_NAME . However, I am having issues with the Navicat and I recently switched on DBeaver(22.0.4 mac). With DBeaver, I cannot execute qu…
Why concatenation does not work in Dbeaver?
Using Dbeaver, the || concatenation does not work. Had to use CONCAT() instead. Got output error message: Truncated incorrect DOUBLE value. Anyone else had this issue? Skill level: Beginner Editor: Dbeaver OS: Windows 7 Answer MariaDB expects the PIPES_AS_CONCAT to be set with the sql_mode to use || as a conc…
Import dump file containing a database dump to dbeaver
I have a database dump in thisdb_2022.dump binary file that I’m trying to import to dbeaver, but I haven’t found a way to import the database so I can see it. I found the below in the dbeaver forum but when I try to follow the instructions and create a new connection I don’t see any option I…
Revisting ORA-06576: not a valid function or procedure name for simple function call via various database tools
Revisting ORA-06576: not a valid function or procedure name for simple function call via dbeaver database-tool I have seen many posts, but they don’t cover the situation I am experiencing. I am trying to do a simple function call to Oracle SQL via dbeaver: According to the right-click call function obta…
Joining two tables but pulling in values only if multiple columns match
I have the query below that assigns a station volume based on the volume processed that week. Station sizes are based by looking at 4 data points throughout the year. This is because station fluctuate in volume throughout the year for example, they may have small volume in one quarter, but large in another. T…
How do I configure one SQL Server to connect to another, so it appears query data is coming from only one connection?
Somewhere recently I read of a method to connect one SQL Server to another, so clients could connect and run queries that appeared to come only from the first server. I cannot remember the proper …
the select convert function not working ! Return the syntax error?
I am using DBeaver. Here is my piece of code: This is the error: [42601]: ERROR: syntax error at or near “,” Because the data is too specific to extend of hour and minute so I want to change it. Not extract details out of it. Please help or at least give me another solution. Answer The CONVERT fun…