PL / SQL在线编译器–在线运行Oracle PL / SQL程序

蔚落 2022-12-08 04:47 602阅读 0赞

In this tutorial you will learn about pl/sql online compiler that will let you run pl/sql programs online.

在本教程中，您将学习pl / sql在线编译器，该编译器使您可以在线运行pl / sql程序。

Few days back I was writing plsql programs to share on this blog. There was no compiler installed on my system to test these programs. So I thought to run them quickly using online compiler. I found only one plsql online compiler that was on Oracle official website. You can’t run the programs directly on it. You have to create account and configure workspace (its one time process only) before using the compiler. As the process was not so easy so I thought to share so that it will be easier for you.

几天前，我正在编写plsql程序以在此博客上分享。 我的系统上没有安装编译器来测试这些程序。 因此，我想使用在线编译器来快速运行它们。 我发现只有一个Oracle官方网站上的plsql在线编译器。 您不能直接在其上运行程序。 在使用编译器之前，您必须创建帐户并配置工作空间(仅其一次性过程)。 由于这个过程并不容易，所以我想分享一下，这样对您来说会更容易。

## 如何在线运行Oracle PL / SQL程序？ **(**How to Run Oracle PL/SQL Programs Online?**)** ##

1. Go to **[https://apex.oracle.com/][https_apex.oracle.com]. **Click on Get Started button.

1.转到**[https://apex.oracle.com/][https_apex.oracle.com] 。** 单击入门按钮。

![Apex Oracle 1][]

2. Click on Free Workspace option.

2.单击可用工作区选项。

![Apex Oracle 2][]

3. Choose Application Development option and click Next.

3.选择“应用程序开发”选项，然后单击“下一步”。

![Apex Oracle 3][]

4. Give first name, last name, email and any workspace name. After that click Next button.

4.输入名字，姓氏，电子邮件和任何工作区名称。 之后，单击下一步按钮。

![Apex Oracle 4][]

5. Give some schema name and choose space allocation. After that click Next.

5.给出一些模式名称并选择空间分配。 之后，单击下一步。

![Apex Oracle 5][]

![Apex Oracle 6][]

6. You will get a little survey, just choose No options and click Next button.

6.您将获得一点调查，只需选择“无选项”，然后单击“下一步”按钮。

7. Now accept the terms and click Next.

7.现在接受条款，然后单击“下一步”。

![Apex Oracle 7][]

8. Click Submit Request button.

8.单击提交请求按钮。

![Apex Oracle 8][]

9. Click on Continue to Sign In Screen button. This will open a sign in screen.

9.单击继续登录屏幕按钮。 这将打开一个登录屏幕。

![Apex Oracle 9][]

10. Open your email account, you got an email from Oracle. There click on Create Workspace button. This will open a screen where you have to setup password.

10.打开您的电子邮件帐户，您收到来自Oracle的电子邮件。 在那里单击创建工作区按钮。 这将打开一个屏幕，您必须在其中设置密码。

![Apex Oracle 10][]

11. Now login using the workspace name, email and the password that you have just created. Remember these details because you will need it whenever you want to use online compiler.

11.现在使用工作区名称，电子邮件和您刚创建的密码登录。 记住这些细节，因为每当您要使用在线编译器时都将需要它。

![Apex Oracle 14][]

12. After login you will see dashboard as given below. Click on SQL Workshop option.

12.登录后，您将看到如下所示的仪表板。 单击SQL Workshop选项。

![Apex Oracle 11][]

13. Click on SQL Commands option.

13.单击“ SQL命令”选项。

![Apex Oracle 12][]

14. This will bring you to editor that allows to write and run plsql programs online.

14.这将带您进入允许在线编写和运行plsql程序的编辑器。

![Apex Oracle 13][]

Setting up of workspace is one time process only. Now you just have to login to use pl/sql online compiler.

设置工作空间仅是一次过程。 现在，您只需要登录即可使用pl / sql在线编译器。

Comment below if you have any doubts regarding above tutorial.

如果您对以上教程有任何疑问，请在下面评论。

> 翻译自: [https://www.thecrazyprogrammer.com/2017/09/plsql-online-compiler.html][https_www.thecrazyprogrammer.com_2017_09_plsql-online-compiler.html]

[https_apex.oracle.com]: https://apex.oracle.com/
[Apex Oracle 1]: https://www.thecrazyprogrammer.com/wp-content/uploads/2017/09/Apex-Oracle-1.png
[Apex Oracle 2]: https://www.thecrazyprogrammer.com/wp-content/uploads/2017/09/Apex-Oracle-2.png
[Apex Oracle 3]: https://www.thecrazyprogrammer.com/wp-content/uploads/2017/09/Apex-Oracle-3.png
[Apex Oracle 4]: https://www.thecrazyprogrammer.com/wp-content/uploads/2017/09/Apex-Oracle-4.png
[Apex Oracle 5]: https://www.thecrazyprogrammer.com/wp-content/uploads/2017/09/Apex-Oracle-5.png
[Apex Oracle 6]: https://www.thecrazyprogrammer.com/wp-content/uploads/2017/09/Apex-Oracle-6.png
[Apex Oracle 7]: https://www.thecrazyprogrammer.com/wp-content/uploads/2017/09/Apex-Oracle-7.png
[Apex Oracle 8]: https://www.thecrazyprogrammer.com/wp-content/uploads/2017/09/Apex-Oracle-8.png
[Apex Oracle 9]: https://www.thecrazyprogrammer.com/wp-content/uploads/2017/09/Apex-Oracle-9.png
[Apex Oracle 10]: https://www.thecrazyprogrammer.com/wp-content/uploads/2017/09/Apex-Oracle-10.png
[Apex Oracle 14]: https://www.thecrazyprogrammer.com/wp-content/uploads/2017/09/Apex-Oracle-14.png
[Apex Oracle 11]: https://www.thecrazyprogrammer.com/wp-content/uploads/2017/09/Apex-Oracle-11.png
[Apex Oracle 12]: https://www.thecrazyprogrammer.com/wp-content/uploads/2017/09/Apex-Oracle-12.png
[Apex Oracle 13]: https://www.thecrazyprogrammer.com/wp-content/uploads/2017/09/Apex-Oracle-13.png
[https_www.thecrazyprogrammer.com_2017_09_plsql-online-compiler.html]: https://www.thecrazyprogrammer.com/2017/09/plsql-online-compiler.html