401 Jul 2011 @ 06:42 PDTDatabaseTopicWhat will occur when a row level lock is requested in a macro and the Optimizer determines a table level lock is required? can you also explain how a row level lock can be requested in macro? and some situations where Optimizer determines for a table level lock? Thanks forum.
306 Jun 2011 @ 12:39 PDTDatabaseReplyBest way to compare contents of two tables?just do simple minus query as your start. sel * from table1 minus sel * from table2; and vice versa if both results show zero rows then u have same data in both tables.
210 Mar 2011 @ 08:07 PSTTrainingReplyHelp Required on TE0-123 exam.Congrats Bujji, could you guide me to clear TE0-121, TE0-122 exams, Thanks and pls mail any helpful material to mail.sunny84@gmail.com Sunny
106 Jun 2010 @ 07:25 PDTDatabaseTopicteradata sql helpthere are two tables table1 and table2 table1 ---columns C1 c2 c3 c4 c5 where c3 and c4 are datebegin and dateend table2----columns d1 d2 c5 where d1 and d2 are dategin and da...