Static SQL: It’s called static because these statements are hard coded and don’t change at every run of the program. As described in the previous section, these statements are It is compiled when the rest of the program is compiled and never again. Static SQL works well when it's implemented at the program or query design time. For example, when you book a flight or order something online, the same design query will be used, only different values will be inserted into a database.These statements are hard-coded into the program and these programs have an advantage that statements need to be parsed, validated, and optimized only once, at compile time and this results in the speed of the program. dynamic SQL: Dynamic SQL is a programming technique that makes it possible to create SQL statements dynamically at runtime. For example, because of dynamic SQL,you can make a procedure that operates on a table whose name is not known until runtime.
You've reached the end of your free preview.
Want to read the whole page?
- Fall '19