PsychSQL is a simple SQL client application intended for data manipulation within an Oracle database using SQL. Connection settings (database URL, username, password) are read from the conf.txt file. If there is no such file, the application creates one with dummy settings when run for the first time. If there is a file called common_tables.txt with a single table name per line, you will see this list of tables as a context menu on typing “FROM” SQL keyword so that a table can be picked from the list.
When a connection to the database has been established, type a SQL query in the upper pane and run it by pressing F9, the results of your query will be displayed in the lower pane.
In the lower pane, left-click on a line and press Ctrl-C to copy the selected record to the clipboard of your operating system and to paste it into the software of your choice afterwards. Press Ctrl-S to save all displayed query results to a file in CSV format.
Set the cursor into the UPPER pane and press Ctrl-S to execute the query and to save the query results directly to a file WITHOUT displaying them in the lower pane. This approach is recommended for a very high number of results that might not fit into the lower pane.
Hold down the Ctrl key and press – or + key to zoom out or in of each pane.
You need Java Runtime Environment version 8 or higher to run PsychSQL:
https://www.java.com/en/
PsychSQL is downloadable as a .zipped file. After un-packing it, you will see the application’s .JAR file (Java executable), as well as the ‘LIB’ folder that holds the RichTextFX component. Besides RichTextFX, PsychSQL needs the Oracle Database 12.2.0.1 JDBC driver, which you have to download from Oracle’s website:
http://www.oracle.com/technetwork/database/application-development/jdbc/downloads/index.html
Place the driver’s JAR file (ojdbc8.jar) in the ‘LIB’ folder.
PsychSQL uses third-party software components:
RichTextFX, Copyright (c) 2013-2017 Tomas Mikula and contributors, dually licensed under BSD 2-Clause License and GPLv2 with Classpath Exception
Download and use for personal non-commercial purposes only.
Version 07.04.2018, CRC32: 108140AD
Download