can we join volatile table with general table an global
temporary table with general table
?
- 4 Answers
- 8988 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rkraju
yes we can join volatile to general table;
>> first we create volatile table
syntax:
create volatile table vt1(x int,y int)on commit preserve rows;
>> we can create general table
syntax:
create table t1(x int,y int,z int);
>>now we can join volatile table and general table
Eg:
select a.x,b.x from vt1 a,t1 b where a.x=b.x;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How many codd's rules are satisfied by teradata database?
What does sleep function does in fast load?
Explain the term 'database' related to relational database management system?
How is MLOAD Client System restarted after execution?
What are the things to be considered while creating secondary index?
What is teradata?
How is MLOAD Teradata Server restarted after execution?
How many tables can you join in v2r5?
What are different table types used in teradata?
What are differences between teradata and ansi session modes in teradata?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What do you mean by fastexport in teradata?
What is logical data model?
What do high confidence, low confidence and no confidence mean in explain plan?
What is the difference between teradata and basic rdbms?
