Stack Overflow
Stack Overflow

Questions tagged [squirrel-sql]

SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

Summary

SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

Website

  • Project Homepage
  • Download squirrel-sql-x.x.x-optional if you want all of the plugins installed.

Features

  • Supports autocomplete when creating queries by pressing CTRL+SPACE.
  • On-the-fly generation of ERD diagrams.

Useful Keyboard Shortcuts

  • CTRL+SPACE - autocomplete database, table, and fields in queries.
  • CTRL+t - SQL Editor Tools Popup
  • CTRL+j - Display Query Bookmarks
    (Note: need to enable with CTRL+t edit bookmarks first.)
  • CTRL+SHIFT+, / CTRL+SHIFT+. - switch to prev/next results tab

Useful Plugins

  • UnityJDBC - A plugin for SQuirreL that allows queries involving multiple kinds of databases, much in the same way that MS-Access allows linked tables.
290 questions
-1
votes
1 answer

Error: Incorrect syntax near the keyword 'RETURN'.SQLState: S0001ErrorCode: 156 when working with Squirrel client

Iam trying to write a PL/SQL function in Squirrel client. when Iam tryin to excute a script in squirrel getting this error. Please help me as Im new to this squirrel client. Script: CREATE FUNCTION totalHoliday RETURN int IS total int:=…
sridhar
  • 11
  • 3
-1
votes
2 answers

To retrieve records having only two specific values

Have the following Data in the table Example Table ID Value 1 a 1 b 1 c 2 a 2 b 2 c 3 a 3 b I need to retrieve records having ID with only two values a and b. So i am expecting only the Record with ID 3 . Can anyone help me with…
user2994034
  • 1
-1
votes
1 answer

Squirrel SQL Error with Oracle Reserved Words

Been scratching my head for a while with what should be a simple Update Statement using the Java Based Squirrel SQL Client, version 3.4.0 (Note: This works fine in TOAD for Oracle, but long term I am expected to use Squirrel. The query is: UPDATE…
DavidBirkin
  • 28
  • 6
-2
votes
1 answer

SQL I have to display the digits 123.34 as 123.3400000000000 ie., 13 digit after the decimal point without loosing any values

Running query from Java code no chance to change the global preferences. I have to print 123.34 as 123.3400000000000 ie. with 13 digits after the decimal point without losing any values CAST(SUM(F.TOTAL_DOCUMENT_CHARS) AS DECIMAL(18,0))/1000 AS…
Kamalakshi M
  • 1
-5
votes
1 answer

I can't identify the database name on DB2 using Squirrel

I want to create a connection from Talend but i coudn't identify the databse name and the schema name , I am using Squierrel client. I changed the database name like on squierrel but I still have the same problem. I think this because the…
HardStacker
  • 1
  • 1
1 2 3
…
19
20