Re:SQL Operations Studio
by genieyclo on Thursday November 16, 2017 @08:45PM
(#15718333)
This is a good time to ask: is there any good SQL IDE for Oracle better than SQL Developer?
[ Parent
| on HN ]
Re:SQL Operations Studio
by bitmapbrother on Thursday November 16, 2017 @10:58PM
(#15718784)
JetBrains DataGrip is pretty good. It's not free, though.
I'd be interested in something better as well. I was testing SQuirrel SQL the other day (have used it before for MSSQL), but the Oracle plugins for it seem to have succumb to bitrot over the past couple of years. UI can hang for minutes on new connections, CTE's aren't recognized as valid syntax, searching Objects is slow and cumbersome.
I know a few people who just use Intellij for it.
Probably not better but have you tried Tora (https://github.com/tora-tool/tora/wiki) or Dbeaver (Eclipse based) or Henplus (universal db shell)?
PL/SQL Developer is excellent but you do have to pay for it. It's not expensive though, much cheaper than TOAD!
Toad used to be a great choice. I would look there.
Re:SQL Operations Studio
by technofire on Friday November 17, 2017 @09:45AM
(#15722300)
Yes, it's called SQL*Plus. Take the time to learn it!