In this section, we will talk about the Environment Setup of PL/SQL. PL/SQL isn't an independent programming language; it is an apparatus inside the Oracle programming climate. SQL* Plus is an intuitive device that permits you to type SQL and PL/SQL proclamations at the order brief. These orders are then shipped off the data set for handling. When the assertions are prepared, the outcomes are sent back and shown on screen.
To run PL/SQL programs, you ought to have the Oracle RDBMS Server introduced in your machine. This will deal with the execution of the SQL orders. The latest rendition of Oracle RDBMS is 11g. You can download a preliminary adaptation of Oracle 11g from the accompanying connection −
You should download either the 32-bit or the 64-bit variant of the establishment according to your working framework. Normally there are two documents. We have downloaded the 64-cycle adaptation. You will likewise utilize comparable strides on your working framework, doesn't make a difference in the event that it is Linux or Solaris.
Subsequent to downloading the over two documents, you should unfasten them in a solitary index data set and under that you will locate the accompanying sub-catalogs −
Allow us currently to dispatch the Oracle Database Installer utilizing the arrangement record. Following is the principal screen. You can give your email ID and check the checkbox as demonstrated in the accompanying screen capture. Snap the Next catch.
You will be coordinated to the accompanying screen; uncheck the checkbox and snap the Continue catch to continue.
Simply select the primary alternative Create and Configure Database utilizing the radio catch and snap the Next catch to continue.
We expect you are introducing Oracle for the fundamental reason for learning and that you are introducing it on your PC or Laptop. Consequently, select the Desktop Class choice and snap the Next catch to continue.
Give an area, where you will introduce the Oracle Server. Simply adjust the Oracle Base and different areas will set consequently. You will likewise need to give a secret key; this will be utilized by the framework DBA. When you give the necessary data, click the Next catch to continue.
Once more, click the Next catch to continue.
Snap the Finish catch to continue; this will begin the genuine worker establishment.
This will take a couple of seconds, until Oracle begins playing out the necessary setup.
Here, Oracle establishment will duplicate the necessary setup records. This should pause for a minute −
When the information base records are duplicated, you will have the accompanying discourse box. Simply click the OK catch and come out.
Upon establishment, you will have the accompanying last window.
It is currently an ideal opportunity to confirm your establishment. At the order brief, utilize the accompanying order on the off chance that you are utilizing Windows −
sqlplus "/ as sysdba"
You ought to have the SQL brief where you will compose your PL/SQL orders and contents −
Running enormous projects from the order brief may land you in unintentionally losing a portion of the work. It is constantly prescribed to utilize the order documents. To utilize the order records −
Type your code in a word processor, similar to Notepad, Notepad+, or EditPlus, and so forth
- Save the document with the .sql augmentation in the home catalog.
- Dispatch the SQL*Plus order brief from the catalog where you made your PL/SQL document.
- Type @file_name at the SQL*Plus order brief to execute your program.
In the event that you are not utilizing a record to execute the PL/SQL contents, at that point basically duplicate your PL/SQL code and right-click on the dark window that shows the SQL brief; utilize the glue choice to glue the total code at the order brief. At long last, simply press Enter to execute the code, in the event that it isn't now executed.