how to get PL/SQL in SQLFiddle?

2020-08-09 09:22发布

Any clues how to get PL/SQL in SQLFiddle?

I've tried

begin
 dbms_output.put_line('Hello World');
end;
/

or

begin
 null; 
end;
/

which works in SQL*Plus (or TOAD or SQLDeveloper or ...) but SQLFiddle just gives me

ORA-06550: line 2, column 36: PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: := . ( % ; : begin dbms_output.put_line('Hello World')

So it seems there is some kind of PL/SQL engine in place but I can't figure out how to get it to parse anonymous program units.

See for example http://www.sqlfiddle.com/#!4/db36d/4

1条回答
2楼-- · 2020-08-09 09:51

As @Lieven correctly pointed out: There is a button below right where you can toggle the query terminator to /.

Working example at http://www.sqlfiddle.com/#!4/db36d/5

查看更多
登录 后发表回答