SQLFiddle 坏了吗？Oracle、SQL Server、...的错误？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/35735405/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Is SQLFiddle broken? Errors for Oracle, SQL Server, ...?
提问by Walter_Ritzel
I'm trying to create a simple table in SQLFiddlefor Oracle database and keep getting the cryptic error:
我正在尝试在SQLFiddle 中为 Oracle 数据库创建一个简单的表并不断收到神秘错误：
Create script error.
创建脚本错误。
Here is a simple script it failed on:
这是一个失败的简单脚本：
create table t1 (f1 number, f2 number, f3 number);
Could anyone can help with that?
任何人都可以帮忙吗？
回答by Steve Chambers
UPDATE:All seems to be working again. See the answer from Jake Feasel(the creator of SQL Fiddle).
更新：一切似乎又恢复了。请参阅Jake Feasel（SQL Fiddle 的创建者）的回答。
To summarise info from the comments as an answer and bring up to date as of writing:
总结评论中的信息作为答案并在撰写时更新：
- SQLFiddle was broken for about a year but as of 2017-07-07 it is working for Oracle 11g R2.
- It also seems to be broken for MS SQL Server 2008, MS SQL Server 2014and MySQL 5.5but MySQL 5.6is working.
- SQLFiddle 被破坏了大约一年，但截至 2017-07-07 它正在为Oracle 11g R2 工作。
- MS SQL Server 2008、MS SQL Server 2014和MySQL 5.5似乎也被破坏了，但MySQL 5.6正在运行。
(Please comment if any of the above changes and I'll update the answer accordingly).
（如果上述任何更改，请发表评论，我会相应地更新答案）。
SQLFiddle Alternatives
SQLFiddle 替代品
- http://rextester.comhas options for MySQL, Oracle, PostgreSQL and SQL Server in the "Language" dropdown (as well as the ability to save work online in a similar way to SQLFiddle).
- http://db-fiddle.comhas options for MySQL 5.5 / 5.6 / 5.7 / 8.0, PostgreSQL 9.4 / 9.5 / 9.6 / 10.0 and SQLite 3.16 / 3.17 / 3.18.
- https://dbfiddle.ukhas options for MariaDB 10.2 / 10.3, MySQL 8.0, Oracle 11g Release 2, Postgres 8.4 / 9.4 / 9.5 / 9.6 / 10 / 11, SQL Server 2012 / 2014 / 2016 / 2017 / 2017 (Linux) and SQLite 3.8 / 3.16 (as well as the ability to save work online in a similar way to SQLFiddle). See further discussion here.
- Suggested alternatives for Oracle are Oracle Application Expressand Oracle Live SQL.
- A MySQL alternative with more limited functionality is sqlize.com.
- A clunky MySQL alternative is sqltest.net(if you can find your way around the adverts).
- As a last resort, I've occasionally seen answers that use Stack Exchange Data Explorerto create custom queries (in SQL Server 2016) that aren't based on the built-in tables. [Disclaimer: I'm not sure it's really supposed to be used for this kind of purpose.]
- http://rextester.com在“语言”下拉列表中有 MySQL、Oracle、PostgreSQL 和 SQL Server 的选项（以及以类似于 SQLFiddle 的方式在线保存工作的能力）。
- http://db-fiddle.com有 MySQL 5.5 / 5.6 / 5.7 / 8.0、PostgreSQL 9.4 / 9.5 / 9.6 / 10.0 和 SQLite 3.16 / 3.17 / 3.18 的选项。
- https://dbfiddle.uk有 MariaDB 10.2 / 10.3、MySQL 8.0、Oracle 11g 第 2 版、Postgres 8.4 / 9.4 / 9.5 / 9.6 / 10 / 11、SQL Server 2012 / 2014 / 2016 / 2017 / 2017 / Linux 的选项和 SQLite 3.8 / 3.16（以及以类似于 SQLFiddle 的方式在线保存工作的能力）。请参阅此处的进一步讨论。
- 建议的 Oracle 替代方案是Oracle Application Express和Oracle Live SQL。
- 一个功能更有限的 MySQL 替代品是sqlize.com。
- 一个笨重的 MySQL 替代方案是sqltest.net（如果你能找到绕过广告的方法）。
- 作为最后的手段，我偶尔会看到使用Stack Exchange 数据资源管理器创建不基于内置表的自定义查询（在 SQL Server 2016 中）的答案。[免责声明：我不确定它是否真的应该用于这种目的。]
回答by Jake Feasel
if you are still interested in using SQL Fiddle I have some good news. Today I have gone live with a new version of the site which aims to improve both performance and reliability. If you are still having trouble, please let me know. Thanks
如果您仍然对使用 SQL Fiddle 感兴趣，我有一些好消息。今天，我已经上线了一个旨在提高性能和可靠性的网站的新版本。如果您仍然遇到问题，请告诉我。谢谢
