954,597 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Recommend SQL Editor

Hi everyone.

Can someone please recommend a SQL editor (other than SQL Developer) that will allow me to test out my SQL statements & queries outside of the DB environment.

I will predominantly be working in a windows environment, but may move to a linux environment at times. Will be most beneficial if the editor is able to connect to both Oracle and SQLServer DB's.

Also I would prefer the editor to be "free" but that is isnt so important.

Any help would much appreciated.
Thanks in advance
Jody

GL.Za
Light Poster
32 posts since Jun 2006
Reputation Points: 10
Solved Threads: 0
 

if you are ready to pay use TOAD or PLSQL DEVELOPER, the best possible tools in market.

debasisdas
Posting Genius
6,872 posts since Feb 2007
Reputation Points: 666
Solved Threads: 434
 

Thanks. how about anything lighter though?

Small in size, doesnt have a heavy installation. Im looking for something portable that I could carry on my flashdrive.

GL.Za
Light Poster
32 posts since Jun 2006
Reputation Points: 10
Solved Threads: 0
 

How much you are ready to invest for the tool ?

debasisdas
Posting Genius
6,872 posts since Feb 2007
Reputation Points: 666
Solved Threads: 434
 
How much you are ready to invest for the tool ?

Lets start at FREE and move up till about $100, preferably no license subscription. ($'s are not currency for my country, but I reckon its an internet standard)

- actually think I will be able to get my hands on Toad, need to negotiate a license from my Manager though. But keep the suggestions coming.

GL.Za
Light Poster
32 posts since Jun 2006
Reputation Points: 10
Solved Threads: 0
 

Then you need to try this .

TOAD does not come in that price range.

debasisdas
Posting Genius
6,872 posts since Feb 2007
Reputation Points: 666
Solved Threads: 434
 

thanks for the help.

GL.Za
Light Poster
32 posts since Jun 2006
Reputation Points: 10
Solved Threads: 0
 

Hi, I use TOAD. Cannot recall the site, but any search engine should show you where to download it (free)

birdman32
Newbie Poster
1 post since Dec 2009
Reputation Points: 10
Solved Threads: 0
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You
View similar articles that have also been tagged: