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

ORA-00926: missing VALUES keyword

I have moved the VALUES clause to different locations in the statement but no luck. I am a Novice and any assistance is appreciated. Thank you. INSERT INTO KEYITEM.296 (KEYVALUECHAR, KEYSETNUM) VALUES ('NOT PUBLIC', 0) SELECT …
Tim Holm
  • 1
  • 1
  • 1
  • 1
-2
votes
1 answer

How to merge multiple rows into one in SQL

How do I merge multiple response Ids into 1 row, so I can left join with another table later on? Data: [ Goal:
msulol
  • 67
  • 6
-3
votes
1 answer

Check for alphas and numerics in

I'm using the dbvisualizer SQL statement and am trying to search a field for whether it has letters and numbers, or just one or the other. Is this possible to do in a simple manner? Currently I'm just checking each one individually like so: case…
Spencer R.
  • 1
-3
votes
1 answer

Equivalent of substring in Impala

-- else left(wof.ro_end_date, 4) + '-' + substring(cast(wof.ro_end_date as varchar(20)), 5, 2) + '-' + right(wof.ro_end_date, 2) This is the code that was originally used in SQL Server Management Studio. Is there any way to do this…
burnsa9
  • 131
  • 2
  • 3
  • 10
1 2 3
…
14
15