what is DYNAMIC SQL in TD?

Answer Posted / yuvaevergreen

dynamic sql is invoking SQL inside a stored procedure during
run time. execute immediate or call can be used to invoke
dynamic sql.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the term 'columns' related to relational database management system?

552


What do you mean by ttu in teradata?

573


What is the use of virtual processor connectivity in teradata?

576


What is upsert statement in teradata?

620


Explain the meaning of Amp?

597






What is oltp?

574


Explain teradata vs. Redshift?

561


Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

1624


Explain and compare pros and cons of start schemas?

550


What are the different methods ot loading a dimension table? A fact table etc?

578


What is teradata?

649


How to select first n records in teradata?

613


what is object level locking ? where do appear this type of locking ?

3117


Comment whether bottleneck is an error or not.

625


What are the different design perspectives used in teradata?

554