![]() PL/SQL is used to write program blocks, functions, procedures, triggers and packages. SQL is used to write queries, create and execute DDL and DML statments. PL/SQL does not directly interacts with database server. I have few SQL queries which has very low query running performance and I want to check the query execution plan for this query. SQL directly interacts with database server. PL/SQL can perform multiple operation at a time. ![]() SQL can execute a single operation at a time. PL/SQL - 529 PL/SQL interview questions and 2286 answers by expert members with experience in PL/SQL subject. PL/SQL has FOR loop, while loop, if controls and other similar structures. SQL has no FOR loop, if control and similar structures. PL/SQL is a programming language using SQL for a database. SQL, is Structural Query Language for database. 6: Embedded: SQL can be embedded in a PL/SQL block. 5: Language Type: SQL is a declarative language. 4: Operations: SQL can execute a single operation at a time. SQL, Structural Query Language is a standard database language which is used create, maintain and retrieve the relational database whereas PL/SQL, Procedural Language extension to SQL, it extends SQL and provide it procedural capabilities.įollowing are the important differences between SQL and PL/SQL. PL/SQL has FOR loop, while loop, if controls and other similar structures. As a developer, the execution plan is probably the best tool at your disposal to discover why a query performs the way it does and, if necessary, figure out what you can do about its performance. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |