What is Static and Dynamic SQL ?
Static and Dynamic
1169
21-Jun-2018
Updated on 22-Jun-2018
Prakash nidhi Verma
22-Jun-2018Differences between Static and Dynamic SQL:
STATIC SQL :
- it's application do not change at runtime.
- the application may allow users to enter their own queries.
- predetermined data
- It is more swift and efficient.
- statements are compiled at compile time.
- It is less flexible.
- can be hard-coded into the application.
DYNAMIC SQL :
- it's application constructed dynamiacally at run time.
- determined data at run time.
- It is less swift and efficient.
- statements are compiled at run time.
- It is more flexible.