Stack Overflow
Stack Overflow

Questions tagged [sqltools]

51 questions
24
votes
6 answers

Extract number from string with Oracle function

I need to create an Oracle DB function that takes a string as parameter. The string contains letters and numbers. I need to extract all the numbers from this string. For example, if I have a string like RO1234, I need to be able to use a function,…
Vali S
  • 1,471
  • 2
  • 10
  • 18
19
votes
10 answers

Is there a "poor man's" alternative to RedGate for scripting out entire database schema?

I'm in a situation where I would to generate a script for a database that I could run on another server and get a database identical to the original one, but without any of the data. In essence, I want to end up with a big create script that…
Michael Lang
  • 2,157
  • 3
  • 22
  • 29
6
votes
0 answers

How to set VS Code SQLTools format settings to match DataGrip SQL format settings?

I'm trying to format my SQL code on VSCode SQLTools to match other team members using DataGrip with Webstorm onto VScode SQLTools but having no luck matching the SQL formatting without installing node modules (repo is for metrics). Does anyone have…
nate21
  • 81
  • 6
4
votes
3 answers

How can I list all databases with Squirrel SQL?

Squirrel SQL would become my favourite SQL tool if only it would have one function: I need to connect to one and only database (alias) and I need to define it manually. Can I connect to all databases or at least browse the databases on server and…
Jarek Jarmołowicz
  • 131
  • 4
3
votes
2 answers

Can't see tables in database when I connect the mysql by sql toos in vscode

When I use vscode extension SQL_tools to connect my local Mysql database, the connection is successful, but I can't see the tables that have been already stored in my database, the issue is "Running the contributed command:…
FrankWu07
  • 39
  • 1
  • 3
3
votes
1 answer

How to join two tables based on a timestamp (with variance of a few seconds)?

I have two tables that I'm trying to join and insert into another table based on a combination of three columns. I'll explain. Table M | ANO | BNO | Timestamp | …
Joshua1729
  • 775
  • 4
  • 10
  • 19
2
votes
1 answer

SQLTool does not commit data after quit (HSQLDB)

i really dont understand the SQLTool... i just want to import a SQL File into the database and choosen this command to do this: java -jar ~/bin/sqltool.jar --autoCommit --inlineRc URL=jdbc:hsqldb:file:/path/to/my/database.hsqldb,USER=SA,PASSWORD=''…
reox
  • 5,036
  • 11
  • 53
  • 98
2
votes
0 answers

DTA - Error while tuning using a Test Server

I have 2 servers, both have SQL Server 2016 Developer edition installed. I want to tuning the production server using a test server, a method described here - Reducing the Production Server Tuning Load. Basically it uses the Test Server to Tune the…
Deepan
  • 95
  • 7
2
votes
1 answer

HSQL SQLTool cant connect

I get the following: java -jar ./sqltool/sqltool.jar inlineRc=url=jdbc:hsqldb:hsql://192.168.99.100/test,user=sa Please enter password for sa!: SqlTool v. 5337. Can't connect to jdbc:hsqldb:hsql://192.168.99.100/test for user…
blacklabelops
  • 4,708
  • 5
  • 25
  • 42
2
votes
1 answer

Strange query behavior oracle 11g

I have a query as: SELECT ps_node_id,name FROM cz_ps_nodes WHERE cz_ps_nodes.ps_node_type=261 START WITH NAME = 'Bundle Rule Repository',cz_ps_nodes.devl_project_id = P_devl_project_id AND cz_ps_nodes.deleted_flag = 0 CONNECT BY PRIOR ps_node_id =…
Nitin Thind
  • 21
  • 3
1
vote
2 answers

Alternative to SQL Tools and Toad IDEs for Oracle query development

Are there any better alternatives to using SQL Tools and TOAD for writing stored procs and queries for Oracle DB? Better in the sense of being able to debugg large queries and stored procedures. Any pointers are welcome!
amit-agrawal
  • 1,563
  • 2
  • 13
  • 24
1
vote
0 answers

Why does my Redshift connection work on DBeaver but not on VSCode SQLTools?

I'm relatively new to SQL, but currently I'm using a VPN trying to connect into a Redshift database. Here are some of the details Driver Name : AWS / Redshift Host : 10.x.xxx.48 Port : 5439 Username : user_name Database : database_name SSL False On…
wel
  • 234
  • 2
  • 11
1
vote
1 answer

Call procedure sql-tool vscode

I couldn't figure out where the problem is! The procedure is successfully created but the call throws the following error: Cannot read properties of undefined (reading 'undefined') Full example: -- @block CREATE TABLE index_table( id INT…
Jaafar Melhem
  • 157
  • 1
  • 7
1
vote
0 answers

vscode shows postgresql query execution error but not the detail

I'm using vscode 1.74.2 with SQLTools extension v0.26.0 with postgresql 15. when I run a query that results in an error in psql it returns error output in several namespaces, for example in my case when i run a function that i created the returns…
ufk
  • 30,912
  • 70
  • 235
  • 386
1
vote
1 answer

Error "Element with id .. already registered" and no SQL connections in the list of VSCode plugin SQLTools

I started learning SQL in VSCode via the SQLTools plugin. I tried to connect to MySQL database sakila via the "Add New Connection" button of the SQLTools plugin. On the first 2 tries, I pushed the "Save Connection" button before the connection was…
GegznaV
  • 4,938
  • 4
  • 23
  • 43
1
2 3 4