#DateForumTypeThreadPost
619 Jul 2016 @ 03:02 PDTDatabaseTopicCHARACTER SET LATIN versus CHARACTER SET UNICODEHi All, I would like to ask for your help on explaining and elaborating the difference between columns having data types set to LATIN and those set to UNICODE. Currently encountering a spool spac...
528 May 2016 @ 02:38 PDTDatabaseReplyEncountered an error using SUM Over Partition byHi All, Can you please explain and give sample queries on how SUM Over partition is used? As per checking it is not possible to only used this function for one aggregated column, thus if your quer...
428 Mar 2016 @ 09:35 PDTDatabaseTopicEncountered an error using SUM Over Partition byHi All, I'm getting an error regarding non aggregate values when using sum over partition function. Basically, my goal is to get the total of a measured column for a particular descriptive col...
323 Oct 2014 @ 10:37 PDTDatabaseReplyFLAT SQL to SET SQLHi Dieter, Yes I already did. I'm having a trouble last time, thinking of ways I can set values to my variable that I forgot to use derived tables .   Thank you for helping out :) MC
222 Oct 2014 @ 03:46 PDTDatabaseTopicFLAT SQL to SET SQLHi All, I need your help in converting FLAT LOGIC(Flat SQL) Stored procedure to a SET LOGIC(SET SQL). From what I understand, a Flat logic is a cursor based SQL while SET logic works on sets of da...
104 Apr 2014 @ 01:37 PDTToolsTopicUSE OF SERIALIZE ON in TPumpHi guys, just want to ask the purpose of Serialize ON in TPUMP. How is it related to the types of blocking or locking if it is not specified in a TPUMP? Are there any circumstances that would affe...