用于试用 Oracle SQL 查询的在线数据库？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/4847767/
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
Online databases for trying out Oracle SQL queries?
提问by devoured elysium
I am studying for an undergraduate databases course.
我正在攻读本科数据库课程。
I'd like to know if there are any online sites that allow me to do queries against an already built and populated database (with a known schema), so I didn't have to install SQL and populate it with data myself.
我想知道是否有任何在线站点允许我对已经构建和填充的数据库（具有已知架构）进行查询，因此我不必安装 SQL 并自己填充数据。
I am currently doing some exercises by hand on a workbook I have here, but I'm a bit afraid that I might be doing them wrong and it's hard to check their correctness without testing them against the "real thing".
我目前正在这里的一本工作簿上手工做一些练习，但我有点担心我可能做错了，如果不根据“真实的东西”测试它们，很难检查它们的正确性。
Thanks
谢谢
(In our course we are using Oracle)
（在我们的课程中，我们使用的是 Oracle）
采纳答案by Mitch Wheat
Have you tried SQLZoo?
你试过SQLZoo吗？
You can (for free) install SQL Server 2008 R2 Express Edition, and download and install already populated databases (such as AdventureWorks2008) from here. Both installs are straight forward.
您可以（免费）安装SQL Server 2008 R2 Express Edition，并从此处下载并安装已填充的数据库（例如 AdventureWorks2008）。两个安装都是直接的。
回答by Sklivvz
If you don't want to go far, do try the StackExchange Data Explorer:
如果您不想走得太远，请尝试使用StackExchange Data Explorer：
About
Stack Exchange Data Explorer allows you to run arbitrary queries on the Stack Exchange public data dumps.
关于
Stack Exchange Data Explorer 允许您在 Stack Exchange 公共数据转储上运行任意查询。
It's fast and supports a SQLServer-like T-SQL syntax.
它速度很快并且支持类似于 SQLServer 的 T-SQL 语法。
回答by Sathyajith Bhat
Give Stack Exchange's Data Explorera spin.
试一试 Stack Exchange 的数据资源管理器。
For Oracle specific queries, you can signup for Oracle's Apexwhich gives you a pre-populated schema based on the Employees/Departments table
对于 Oracle 特定查询，您可以注册Oracle 的 Apex，它为您提供基于员工/部门表的预填充架构
回答by ocodo
You can easily install MySQL/PostgreSQL/SQL Server Express and get up and running, also whatever test data might be installed on a publicly available server won't necessarily stay the same between queries, since anyone can access it.
您可以轻松安装 MySQL/PostgreSQL/SQL Server Express 并启动并运行，而且任何可能安装在公共可用服务器上的测试数据在查询之间不一定保持不变，因为任何人都可以访问它。
So just go ahead and install one of the above, you'll thank yourself in the near future.
因此，请继续安装上述之一，您将在不久的将来感谢自己。
回答by Luke Stevenson
Maybe not exactly what you are looking for, by SQLZoo Tutorials allow you to practice some basic interactions, and also allow you to interact with a number of different SQL Engines.
也许不是您正在寻找的，SQLZoo 教程允许您练习一些基本的交互，还允许您与许多不同的 SQL 引擎进行交互。
回答by Chingiz Musayev
Try out this Interactive SQLsite. It looks what are you looking for
试试这个 Interactive SQL站点。看起来你在找什么
回答by icc97
You could try installing WAMP Server. This comes with MySQL and a UI of phpMyAdmin that you can use to install and test databases. Then you can install the MySQL test employees database.
您可以尝试安装WAMP Server。它带有 MySQL 和 phpMyAdmin 的 UI，可用于安装和测试数据库。然后就可以安装 MySQL测试员工数据库了。
回答by Sparky
For very simple queries, you can try SQL queries online in the W3Schools SQL Try It page - http://www.w3schools.com/sql/sql_tryit.asp
对于非常简单的查询，您可以在 W3Schools SQL Try It 页面在线尝试 SQL 查询 - http://www.w3schools.com/sql/sql_tryit.asp
Or you can use the online demo of phpMyAdmin at http://demo.phpmyadmin.net/STABLE/?pma_username=rootfor deeper use.
或者您可以使用http://demo.phpmyadmin.net/STABLE/?pma_username=root 上的 phpMyAdmin 在线演示进行更深入的使用。
回答by Sushant Butta
Oracle Apex provides online space for you to create and execute your sql queries. Please create an account with Oracle Apex and then enjoy with your personalised tablespace and schema. This is freeware and Oracle doesn't charge anything for this. It is the best way if you don't want to install Oracle on your system and don't want to slow down your system. Another advantage of Oracle Apex is that you have all your tables and data online and you don't have to maintain it, Oracle will do that for you. You can access your database from anywhere you want.
Oracle Apex 为您提供在线空间来创建和执行您的 sql 查询。请在 Oracle Apex 中创建一个帐户，然后享受您的个性化表空间和架构。这是免费软件，Oracle 对此不收取任何费用。如果您不想在系统上安装 Oracle 并且不想降低系统速度，这是最好的方法。Oracle Apex 的另一个优势是您可以在线拥有所有表和数据，而无需维护它们，Oracle 会为您做这些。您可以从任何地方访问您的数据库。
