{"id":22049,"date":"2013-05-13T10:24:15","date_gmt":"2013-05-13T04:54:15","guid":{"rendered":"http:\/\/vskills.in\/certification\/tutorial\/?p=22049"},"modified":"2024-04-12T14:16:42","modified_gmt":"2024-04-12T08:46:42","slug":"plsql-introduction","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/plsql-introduction\/","title":{"rendered":"PL\/SQL Introduction"},"content":{"rendered":"\n

Certify and Increase Opportunity.<\/span>
Be <\/span>
Govt. Certified PL SQL Developer<\/span><\/a><\/p>\n\n\n

\n
\"plsql\"<\/a><\/figure>\n<\/div>\n\n\n

PL\/SQL stands for Procedural Language extension of SQL. PL\/SQL is a combination of SQL along with the procedural features of programming languages. It was developed by Oracle Corporation in the early 90\u2019s to enhance the capabilities of SQL.<\/p>\n\n\n\n

Procedural Language\/Structured Query Language (PL\/SQL) is Oracle Corporation’s procedural extension language for SQL and the Oracle relational database. PL\/SQL’s general syntax resembles that of Ada or Pascal. It is also one of three key programming languages embedded in the Oracle Database, along with SQL itself and Java.<\/p>\n\n\n\n

PL\/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).<\/p>\n\n\n\n

PL\/SQL supports variables, conditions, loops and exceptions. Arrays are also supported, though in a somewhat unusual way, involving the use of PL\/SQL collections.<\/p>\n\n\n\n

Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation.<\/p>\n\n\n\n

Once the program units have been stored into the database, they become available for execution at a later time.<\/p>\n\n\n\n

While programmers can readily embed Data Manipulation Language (DML) statements directly into their PL\/SQL code using straightforward SQL statements, Data Definition Language (DDL) requires more complex “Dynamic SQL” statements to be written in the PL\/SQL code. However, DML statements underpin the majority of PL\/SQL code in typical software applications.<\/p>\n\n\n\n

In the case of PL\/SQL dynamic SQL, early versions of the Oracle Database required the use of a complicated Oracle DBMS_SQL package library. More recent versions have however introduced a simpler “Native Dynamic SQL”, along with an associated EXECUTE IMMEDIATE syntax.<\/p>\n\n\n\n

Oracle Corporation customarily extends package functionality with each successive release of the Oracle Database.<\/p>\n\n\n\n

This topic includes –<\/p>\n\n\n\n