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

Reply via email to