Juan, It's an issue of writing a complete interactive application, which is just really nasty in sqlplus. Dbms_output is inadequate on the output side, and using "&" and "&&" in the input side is even worse than that... "Nullius in verba" means, "Don't take anybody's word for it." It has been the motto of the Royal Society of England for a few centuries. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com * Nullius in verba * Upcoming events: - Performance Diagnosis 101: 2/24 San Diego, 3/23 Park City, 4/6 Seattle - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Juan Cachito Reyes Pacheco Sent: Friday, February 20, 2004 9:33 AM To: oracle-l@xxxxxxxxxxxxx Subject: Re: SQLPlus -- replacement tool Did you tried to use instead sql plus dynamic sql and stored procedures in a package? Unless you do a very very unique scripts, or you want the script ask your input every time, to see any kind of output you can use dbms_output.put_line package and run that package from sql plus. I think this could help you. Other chance is to use java in the database, java can run OS commands. What means * Nullius in verba *? :) ----- Original Message ----- From: "Cary Millsap" <cary.millsap@xxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Friday, February 20, 2004 11:02 AM Subject: RE: SQLPlus -- replacement tool I'm interested in this conversation because scripting in sqlplus is so horrific. The SQL optimization harness we've written to sit atop sqlplus is 10x more lines of code that we want it to be, and it still fails to offer basic features that we'd expect from a real scripting language. For example, you I don't think you can test whether a variable (e.g., a command line arg) has been set without prompting for its value if its value is undefined. Stuff like that... So, to twist the conversation slightly, is there a more decent sqlplus-like scripting tool out there? What I'd love to find is a sqlplus-alike that lets me use Perl or Korn shell syntax instead of just SQL and the meager set of sqlplus set commands... Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com * Nullius in verba * Upcoming events: - Performance Diagnosis 101: 2/24 San Diego, 3/23 Park City, 4/6 Seattle - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mladen Gogala Sent: Friday, February 20, 2004 8:17 AM To: oracle-l@xxxxxxxxxxxxx Subject: Re: SQLPlus -- replacement tool I use "vim". It has "set syntax=oracle" command, or, my favorite, "set syntax=perl", and it isn't as expensive as UltraEdit32. I have yet to find an editor capable of supporting regular expressions as well as "vi". And you know what: it's everywhere where I go. There is a "vi" version for everything, with the possible exception of IBM mainframe. IBM mainframes have been appropriately named: the latest and the greatest is called "T-Rex" (not a joke, it's true). Asteroid is traveling fast and Jurassic is coming to an end. On 02/20/2004 09:00:07 AM, "Freeman, Donald" wrote: > I use UltraEdit32. Its a programming text editor with about 1000 built = > in functions. I think a single license copy is $35. It supports sql and = > pl/sql syntax highlighting, column editing (which I used extensively to = > create a million sql statements at a time), very large file support, = > built in ftp client, regular expressions, most unix like functions, like = > grep, sort, uniq, multiple clipboards, templates, macros. You can edit = > in hex, ascii, ebcdic, unix, mac. It has won several awards. I have = > been using it in combination with sqlplus for five years. I have both = > TOAD and DBArtisan but prefer Ultraedit. It's possible that it can be = > linked directly to sqlplus. I know you can run programs from it but = > haven't tried to link it. You can make it your default editor. It has = > improved my sql productivity 100%. =20 > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------