Pl/sql is a completely porrtable,high permormance transaction processing language.whic offers the following advantages.
Disadvantages of PL/SQL – PL/SQL is a specialized programming language, which may require developers to invest time and effort in learning and mastering the language. Potentially leading to security vulnerabilities – PL/SQL code can introduce security vulnerabilities if it is not properly designed and implemented. Being prone to errors – PL/SQL code can be prone to errors, particularly if it is complex or poorly written. Being resource-intensive – PL/SQL code can be resource-intensive, which can impact the performance and scalability of database applications.Pl/sql is a completely porrtable,high permormance transaction processing language.whic offers the following advantages.
1.Requiring specialized knowledge:->PL/SQL is a specialized programming language, which may require developers to invest time and effort in learning and mastering the language.
2.Being limited to Oracle databases :-> PL/SQL is specific to Oracle databases, which can limit its use and compatibility with other database management systems.
3.Potentially leading to security vulnerabilities :->PL/SQL code can introduce security vulnerabilities if it is not properly designed and implemented..
4.Being prone to errors :->PL/SQL code can be prone to errors, particularly if it is complex or poorly written.
5.Being resource-intensive:->PL/SQL code can be resource-intensive, which can impact the performance and scalability of database applications.
Every constant and variable has a data type,which specifies a storage format,constraints,and a valid range of values.