Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • Are you hearing me Oracle? You command line client is awful. It sucks very, very hard. Yes, you have all of these neat features that are very useful, but for grunts like me, I want a tool that makes the common tasks easy. Give me autocompletion. Give me a friggin' up arrow. Give me a break.

    I agree so hard it hurts. That's why I use TOAD [toadsoft.com].

  • I remember thinking the same thing... six years ago! You could try the same thing I tried back then, DBI::Shell [cpan.org]?
    • There are error messages (like which line of SQL had a problem) which I get with sqlplus but not through DBI. For me that is a critical feature, since I'm generally not trying to interactively understand Oracle through the command line, but rather I'm trying to debug some SQL that is misbehaving (eg a large hunk of sql refuses to compile).

      Oracle's error messages suck nearly as badly as its command line client, and I see no reason to make them suck any worse than they have to.
  • I think I remember that you use vi, but Emacs has an Oracle mode that's better than SQL Plus. If you use etags on the DDL files, you get command completion on tables and fields etc.