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
What is meant by a Highest Cost Plan?
What are the components provided on node?
List out all forms of LOCKS that are available in Teradata.
How to identify ppi columns?
Can you fastexport a field, which is primary key by putting equality on that key?
Highlight the advantages of PPI(Partition Primary Index).
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
How to find duplicates in a table?
Explain the term 'foreign key' related to relational database management system?
What is teradata?
Describe the between keyword in teradata?
What is inner join and outer join?
Highlight the limitations of TPUMP Utility.
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
Difference between stored procedure and macro?
