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

Differentiate pl/sql and sql?

565


How you can copy a file to file content and file to pl/sql table in advance pl/sql?

620


what are date and time data types in mysql? : Sql dba

504


What are stored procedures in mysql?

566


Can we use insert statement in function?

516






What is dynamic query?

542


What is sql used for?

647


What are primary key and foreign key and how they work?

556


What is sql select statement?

506


How many joins in sql?

558


Is sqlite thread safe?

609


What is trigger point?

540


How to rename a column in the output of sql query?

539


What is offset in sql query?

598


Is sql port 1433 encrypted?

578