设置开发环境以学习PL/SQL [英] Setting up a development environment to learn PL/SQL
问题描述
我想设置一个沙箱环境来磨练自己的pl/sql和数据库技能.我当时正在考虑下载Oracle 11G的完整版本并使用SQL Developer.建立测试数据库并从那里开始工作.
I want to setup a sandbox environment to hone in on my pl/sql and database skills. I was thinking of downloading the full version of Oracle 11G and using SQL Developer. Setting up a test database and working from there.
有什么建议吗?您认为这是个好方法吗?
Any recommendations? Do you think this is a good approach?
提前谢谢!
推荐答案
如果您想对整个环境进行沙盒化,Oracle提供了预先构建的VM映像,其中包含一个11g数据库,SQL Developer和其他工具.更多信息此处,如果您只想使用PL/SQL, 列出的第一个版本应具有所需的一切.
If you want to sandbox the whole environment, Oracle provide pre-built VM images which contain an 11g database, SQL Developer and other tools; more info here, and if you just want PL/SQL the first version listed should have everything you need.
它设置起来非常快捷,容易-不需要DBA知识-它与您要避免干扰的任何实际环境完全隔离,可以在运行VirtualBox的任何计算机和O/S上运行,并且最好全部,如果(或何时)您真的弄乱了东西,可以将其丢弃并重新开始.
As well as being very quick and easy to set up - no DBA knowledge required - it's completely isolated from any real environments you want to avoid interfering with, can run on any machine and O/S that runs VirtualBox, and best of all, if (or when) you really mess something up you can trash it and start again.
这篇关于设置开发环境以学习PL/SQL的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!