Posts

Showing posts from September, 2016

The ListAgg Function : Oracle SQL

LISTAGG: The Oracle/PLSQL LISTAGG function concatenates values of the  measure_column  for each GROUP based on the order_by_clause . Syntax The syntax for the LISTAGG function in Oracle/PLSQL is: LISTAGG (measure_column [, 'delimiter']) WITHIN GROUP (order_by_clause) [OVER (query_partition_clause)] Parameters or Arguments measure_column The column or expression whose values you wish to concatenate together in the result set. Null values in the  measure_column are ignored. delimiter Optional. It is the delimiter to use when separating the  measure_column  values when outputting the results. order_by_clause It determines the order that the concatenated values (ie:  measure_column ) are returned. https://www.techonthenet.com/oracle/functions/listagg.php Explained: Imagine a situation where, where you want to parse the multiple results of an unique identifier in single line. Like Parse all the Items associated with that oLPN Find all the...

Thank you !

Thank You My Dear God! Today, I am starting with with this blog, to capture all my learning, my experience and like we say, before starting anything we should start it with remembering our dear god and thanking him and i just want to say " Thank you " "Jai Mata Di" Thank you god for this day, this moment  you have given me everything, and would like to thank you with all my heart. I believe what ever thing happens, happens for something good.  You are the mastermind, your planning can never fail, we are just a small creature, which are meant to make mistakes. I e ven  don't know how to thank you! Thank you papa ji and mummy ji!