If table have access lock.In the same table write lock is
posible or not?
Answer / yuvaevergreen
yes...its possible...when access lock is present in a table, write lock can be inteded for the the same table.
| Is This Answer Correct ? | 8 Yes | 0 No |
Hi All, I have a table with 3 fields like id,mark1,mark2 and I would like to update a mark3 field that would calculate the max for each record (so the max value of the 2 fields) in Teradata ID Mark1 Mark2 Mark3 1 10 20 2 20 30 3 40 10 4 50 50 I Have to write a update statement Mark3 with max value of mark1,mark2 fields…like bellow ID Mark1 Mark2 Mark3 1 10 20 20 2 20 30 30 3 40 10 40 4 50 50 50 Please any one help me ....Thq
Can we collect statistics on table level?
Explain BYNET.
What are the enhanced features in teradata v2r5 and v2r6?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What's the syntax of sub string?
What is the use of virtual processor connectivity in teradata?
Why MLOAD needs Work Tables?
what are the uses of fact table and dimension table in banking project?
A Query was run fine earlier. It is not running properly now. what are proactive steps you can take as a dba ?
Which is more efficient group by or distinct to find duplicates?
What is a common data source for the central enterprise data warehouse?