Shulou(Shulou.com)06/01 Report--

Editor to share with you what are the differences between static and dynamic sql, I believe most people still do not understand, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Static or embedded SQL are SQL statements in an application that do not change at run time, so they can be hard-coded into the application. Dynamic SQL is a SQL statement that is constructed at run time. For example, an application can allow users to enter their own queries.

Dynamic SQL is a programming technique that enables you to build SQL statements dynamically at run time. You can use dynamic SQL to create more general-purpose, flexible applications, because you may not know the full text of the SQL statement at compile time.

The following are the basic differences between Static or Embedded and Dynamic or Interactive SQL:

Static (embedded) SQL dynamic (Interactive) SQL in Static SQL, how to access the database is predetermined in the embedded SQL statement. In Dynamic SQL, how to access the database is determined at run time. It is faster and more effective. It's not so fast and effective. SQL statements are compiled at compile time. SQL statements are compiled at run time. Parsing, validation, optimization, and application plan generation are completed at compile time. Parsing, validation, optimization, and generation of application plans are completed at run time. It is usually used in situations where data is evenly distributed. It is usually used in situations where data is unevenly distributed. Do not use EXECUTE IMMEDIATE,EXECUTE and PREPARE statements. Use EXECUTE IMMEDIATE,EXECUTE and PREPARE statements. It is less flexible. It's more flexible.

Limitations of dynamic SQL:

We cannot use certain SQL statements dynamically.

The performance of these statements is poor compared to Static SQL.

Limitations of static SQL:

They do not change at run time, so they are hard-coded into the application.

These are all the differences between static and dynamic sql. Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.