# | Date | Forum | Type | Thread | Post |
6 | 19 Jul 2016 @ 03:02 PDT | Database | Topic | CHARACTER SET LATIN versus CHARACTER SET UNICODE | Hi 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... |
5 | 28 May 2016 @ 02:38 PDT | Database | Reply | Encountered an error using SUM Over Partition by | Hi 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... |
4 | 28 Mar 2016 @ 09:35 PDT | Database | Topic | Encountered an error using SUM Over Partition by | Hi 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... |
3 | 23 Oct 2014 @ 10:37 PDT | Database | Reply | FLAT SQL to SET SQL | Hi 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
|
2 | 22 Oct 2014 @ 03:46 PDT | Database | Topic | FLAT SQL to SET SQL | Hi 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... |
1 | 04 Apr 2014 @ 01:37 PDT | Tools | Topic | USE OF SERIALIZE ON in TPump | Hi 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... |
|
|