Try: DROP TABLE // CREATE TABLE BLALBLA // INSERT ...
Markus -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tobias Oberstein Sent: Sunday, February 09, 2003 11:26 AM To: [EMAIL PROTECTED] Subject: SQL Studio usage I'm feeling like an idiot trying to get multiple SQL statements run in SQL Studio. I'd like to run short scripts either from beginning to end, only a marked part of a dialog, or just the statement the cursor is currently positioned. DROP TABLE BLABLA CREATE TABLE BLABLA .. .. .. What's the line seperator?? I coming from Oracle, where you would write DROP sdkjfhsk; or DROP sdfsdf / I didn't find anything such trivial in the dox;( Also, how can write "anonymous procedure block" like e.g. what would be the equivalent to DECLARE l_int INTEGER; l_string VARCHAR(100); BEGIN CALL MYPROC (:l_int, :l_string); DBMS_OUTPUT.put_line (l_int || " " || l_string); END; Thanks a lot, Tobias _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 1/27/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 1/27/2003 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
