Probably the best bit about SQLpal though is the fact that it just unzips to a directory (no install needed), and it connects via JDBC, therefore not needing an Oracle Client install on your PC. Perfect for putting on a USB keychain drive, for use when you've not got the Oracle Client installed on a machine or you want to use something more user-friendly than SQL*Plus.    – Mark Rittman



 

As a replacement for SQL*Plus, SQLpal offers the following features:

  • syntax highlighting (in Scratchpad tab)
  • auto-completion of table names and columns (in Scratchpad tab)
  • up arrow brings back previous command (in SQL Prompt tab)
  • read-only schema browser, supports editing PL/SQL functions, procedures, packages
  • F7 to view command history
  • can bookmark frequent used sql statements
  • assign hot key to frequently used sql statements
  • save grid as html
  • one click to open result grid in Excel
  • can open multiple windows for connecting to multiple databases
  • uncompromising native Windows user interface
  • does not require Oracle client to be installed
  • does not require tnsnames.ora, instead just enter the host, port and sid

Download

Download: sqlpal.zip for Windows XP, Windows 2000 and Windows NT 4.0 (Last updated September 8, 2004)

Contact us

Got an idea for a new feature? Found an annoying bug? Let us know: