Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / nilesh
Dynamic SQL enables you to write programs that reference
SQL statements whose full text is not known until runtime.
Before discussing dynamic SQL in detail, a clear definition
of static SQL may provide a good starting point for
understanding dynamic SQL. Static SQL statements do not
change from execution to execution. The full text of static
SQL statements are known at compilation, which provides the
following benefits:
Successful compilation verifies that the SQL statements
reference valid database objects.
Successful compilation verifies that the necessary
privileges are in place to access the database objects.
Performance of static SQL is generally better than dynamic
SQL.
Because of these advantages, you should use dynamic SQL
only if you cannot use static SQL to accomplish your goals,
or if using static SQL is cumbersome compared to dynamic
SQL. However, static SQL has limitations that can be
overcome with dynamic SQL. You may not always know the full
text of the SQL statements that must be executed in a
PL/SQL procedure. Your program may accept user input that
defines the SQL statements to execute, or your program may
need to complete some processing work to determine the
correct course of action. In such cases, you should use
dynamic SQL.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is dll hell, and how does .net solve it?
What is continue in c#?
What is difference between array and collection?
What are the 3 different types of arrays?
What is data adapter in c#?
What are Indexers in C#?
What are floating point numbers?
What the different phase/steps of acquiring a proxy object in webservice?
What is difference between constants and readonly in c#?
What are indexers in c# .net?
Define multicast delegate? How it be used?
What are the different types of comments in c#?
What is a dbml?
hi all.... i need code snippets for store and retrive tiff fromat images in sqlserver....... kindy provide it.......
How can you achieve run time polymorphism in C#?
