#Pl sql developer history buffer windows#

On a Windows client, you can just run sql.exe and be on your way. Once youвЂ™ve unzipped the tool, go to the bin directory. You are rewarded with posession of 11MB worth of :

#Pl sql developer history buffer download#

Instead, you simply need to head over to the SQLDeveloper Download Page and download Command Line SDSQL вЂ“ All Platforms. This is a pretty good start as you donвЂ™t have to figure out which files you need to download before you get going. The first thing youвЂ™ll notice about SDSQL is that, unlike the Oracle Client of which SQL*Plus is a component, it is a single file.

Improvements in command-line interaction incorporating Linux-like and IDE features, including glorious technicolour!ДЄll of which leaves the ageing geek in me unashamedly excited.Д«efore I go on, I should take this opportunity to say thanks to Jeff Smith and the team for answering the questions I had about some of the new features.

How SQLCL differs вЂњstructurallyвЂќ from SQL*Plus.

Whilst the decision has been taken to ensure that SQLCL is fully backward-compatible with the current SQL*Plus, some of the new features may well have significant implications in the way that the Oracle CLI is used in the future. Whilst the currently available versions of SQLCL are very much in the Early Adopter stage, there is enough there to show the direction in which things are moving. It has also been known as SDSQL (SQLDeveloper SQL) and even SQL*Plus++ (my personal favourite). SQL*Plus for the 21st Century is currently going by the name of SQLCL (SQL Command Line). Increasingly, it will also include jobs that are initiated as part of Continuous Integration or Release Management testing. These will include batch jobs managed by a scheduling tool external to the Oracle RDBMS, such as Autosys, or even good old CRON. More common though, are those jobs that need to run unattended. Interactive connection to a database from a server thatвЂ™s not running a desktop environment would be one. Well, there are still some things that you need the command line for. You may be wondering how this is in any way relevant in the modern world of GUI development. Now, however, it looks like things are about to change as Oracle lavish some attention on the noble CLI. Whilst there have been some changes here and there, itвЂ™s basic functionality has remained largely unchanged over the intervening 30 years. The command line interface to Oracle Databases has been around, in itвЂ™s current guise, since 1985. Something else that doesnвЂ™t seem to change much over time is SQL*Plus.

To borrow a well-known saying, One-Day International Cricket is a game played by two sides for 100 oversвЂ¦and then the Aussies win the World Cup.