Ave ! Here is one possible solution.
Create two tiny scripts. First script let say ex.sql which includes only word exit and linefeed and second one cont.sql which has only one space character, nothing else. Then in Your sql script: -- column NAME noprint new_value SCRIPT_NAME select decode(name,'TEST','cont.sql','ex.sql') NAME from v$database; @&SCRIPT_NAME -- So if Your database is TEST, then You run cont.sql (nothing happens), but if it's something else, You run ex.sql which stops Your sqlplus session. HTH Jorma -----Original Message----- Sent: 17 June, 2003 07:39 To: Multiple recipients of list ORACLE-L I have a script and can be run on commandline like: > sqlplus <usrname>/<password>@TEST @import.sql However, I want to check database name at the beginning of import.sql. I knew "select name from v$database" can obtain database name. But how can I stop the script if I found it is not TEST database? In import.sql, it is like: drop user A cascade; create user A ....; host imp A/[EMAIL PROTECTED] file=a.dmp full=yes; // some PL/SQL ... Thanks! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
