如何在SQLFiddle中获取PL/SQL? [英] how to get PL/SQL in SQLFiddle?

问题描述

任何线索如何在SQLFiddle中获取PL/SQL?

Any clues how to get PL/SQL in SQLFiddle?

我尝试过

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

或

begin
 null; 
end;
/

可在SQL * Plus(或TOAD或SQLDeveloper或...)中使用，但SQLFiddle只是给我

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')

因此，似乎已经有了某种PL/SQL引擎，但我不知道如何获取它来解析匿名程序单元.

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.

例如参见 http://www.sqlfiddle.com/#!4/db36d/4

推荐答案

正如@Lieven正确指出的那样:右下方有一个按钮，您可以在其中将查询终止符切换为/.

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

在http://www.sqlfiddle.com/#!4/db36d /5

这篇关于如何在SQLFiddle中获取PL/SQL?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！