SQLFiddle是否损坏? Oracle，SQL Server等错误...? [英] Is SQLFiddle broken? Errors for Oracle, SQL Server, ...?

问题描述

我正在尝试在 SQLFiddle 中为Oracle数据库创建一个简单的表，并不断收到隐秘的错误:

I'm trying to create a simple table in SQLFiddle for Oracle database and keep getting the cryptic error:

创建脚本错误.

Create script error.

这是一个失败的简单脚本:

Here is a simple script it failed on:

create table t1 (f1 number, f2 number, f3 number);

任何人都可以帮忙吗?

推荐答案

更新:一切似乎都可以正常工作.参见 Jake Feasel的回答(SQL Fiddle的创建者).

UPDATE: All seems to be working again. See the answer from Jake Feasel (the creator of SQL Fiddle).

总结评论中的信息作为答案，并在撰写本文时提供最新信息:

To summarise info from the comments as an answer and bring up to date as of writing:

1. SQLFiddle损坏了大约一年，但是从2017年7月7日开始，它可用于 Oracle 11g R2 .
2. 对于 MS SQL Server 2008 ， MySQL 5.5 ，但 MySQL 5.6 正常工作.

1. SQLFiddle was broken for about a year but as of 2017-07-07 it is working for Oracle 11g R2.
2. It also seems to be broken for MS SQL Server 2008, MS SQL Server 2014 and MySQL 5.5 but MySQL 5.6 is working.

(如果上述任何更改，请发表评论，我将相应地更新答案).

SQLFiddle替代项

1. http://rextester.com 在语言"下拉列表中具有针对MySQL，Oracle，PostgreSQL和SQL Server的选项(以及以类似于SQLFiddle的方式在线保存工作的功能).
2. http://db-fiddle.com 具有适用于MySQL 5.5/5.6/5.7/5.7/8.0，PostgreSQL的选项9.4/9.5/9.6/10.0和SQLite 3.16/3.17/3.18.
3. 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的方式在线保存工作的功能).请参见此处.
4. 建议的Oracle替代品为 Oracle Application Express 和 sqlize.com .
5. 笨拙的MySQL替代品是 sqltest.net (如果您能找到解决广告问题的方法).
6. 作为最后的手段，我偶尔看到使用 Stack Exchange Data Explorer 创建不基于内置表的自定义查询(在SQL Server 2016中). [免责声明:我不确定它是否真的应该用于这种目的.]

1. http://rextester.com has 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).
2. http://db-fiddle.com has 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.
3. https://dbfiddle.uk has 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.
4. Suggested alternatives for Oracle are Oracle Application Express and Oracle Live SQL.
5. A MySQL alternative with more limited functionality is sqlize.com.
6. A clunky MySQL alternative is sqltest.net (if you can find your way around the adverts).
7. As a last resort, I've occasionally seen answers that use Stack Exchange Data Explorer to 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.]

这篇关于SQLFiddle是否损坏? Oracle，SQL Server等错误...?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！