what are Dynamic SQL statements?

Answer Posted / thanvi

Both compilation and execution happens at the time.It will be useful where we don't know (the value of col_name or table_name) till runtime.
-Compilation means checks for the syntax.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to disable a trigger name update_salary?

645


how to use case expression? : Sql dba

528


how to use like conditions? : Sql dba

543


what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

468


what are the authentication modes in sql server? How can it be changed? : Sql dba

677






How many types of normalization are there?

467


What is the order of sql select?

542


How do I write a sql query in pgadmin 4?

531


What is view explain with example?

493


what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

518


Which join condition can be specified using on clause?

498


Is inner join same as self join?

550


What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

528


How do I view a procedure in sql?

525


what are string data types? : Sql dba

483