database 我在哪里可以“练习”PL/SQL

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/4920307/
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

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-08 08:03:04  来源:igfitidea点击:

Where can I "practice" PL/SQL

databaseplsql

提问by twinzen

I will be given a job offer by an IT company, and was asked to "look at" PL/SQL since I didn't have much experience with databases. I have an extensive background in C++ among other programming languages, so I don't think this will pose too much of a challenge. However, I don't have access to any Oracle database at home, so I was wondering if there is a "toy" database and terminal online where I can practice.

我将获得一家 IT 公司的工作机会,并被要求“研究”PL/SQL,因为我对数据库没有太多经验。我在 C++ 和其他编程语言方面拥有广泛的背景,所以我认为这不会带来太大的挑战。但是,我在家里无法访问任何Oracle数据库,所以我想知道是否有一个可以练习的“玩具”数据库和终端在线。

回答by Adnan

Register yourself an account at APEX ONLINEyou have all of the tools for free available online, or simple download Oracle Database 10g Express Edition

APEX ONLINE注册一个帐户,您可以在线免费获得所有工具,或者只需下载Oracle 数据库 10g 快捷版

回答by Jeffrey Kemp

I would suggest a higher priority would be to learn the Relational model of data, then SQL.

我建议优先学习数据的关系模型,然后是 SQL。

If you don't start with a solid understanding of the RM, you're more likely to tend to use procedural solutions where a set-based approach is better.

如果您没有对 RM 有充分的了解,那么您更有可能倾向于使用基于集合的方法更好的程序解决方案。

回答by spudgun

Go and get the Express version of the database server Here

这里获取数据库服务器的 Express 版本

As for learning PL/SQL start here

至于学习PL/SQL从这里开始

回答by sdrsurendhar

回答by Doomineer

There is another site where you can practice PL/SQL online: http://www.tutorialspoint.com/oracle_terminal_online.php

还有一个可以在线练习 PL/SQL 的站点:http: //www.tutorialspoint.com/oracle_terminal_online.php

Oracle have some VM images with Oracle Linux ready-to-run: http://www.oracle.com/technetwork/server-storage/linux/downloads/vm-for-hol-1896500.html(64bits VM)

Oracle 有一些可以运行 Oracle Linux 的 VM 映像:http: //www.oracle.com/technetwork/server-storage/linux/downloads/vm-for-hol-1896500.html(64 位 VM)

回答by Paola Medina

To learn PL/SQL language you just need a text editor like atom or sublime text. You can also install MySQL.

要学习 PL/SQL 语言,您只需要一个文本编辑器,如 atom 或 sublime text。您也可以安装 MySQL。