Oracle New Features for developers | ORACLE LISTAGG function from oracle 11g to 19c

[@Avinash.karmwar]

Best Channel for Oracle Plsql learning...keep up the good work. The way you explain is really very good

[@piyushdubey4498]

Best KZbin channel for SQL and PLSQL videos. Keep doing the good work.

[@SivaAcademy]

Thank you bro

[@Rajugupta-gp2eg]

This is the best explanation one can ever expect. Thank you.

[@SivaAcademy]

My pleasure bro, thank you

[@vidhyarenganathan8696]

Thank you so much. Simple and awesome explanation!!! Appreciate your help for newbies like me!!

[@mohitkumar1854]

Thanks A lot Sir.... Awesome way of teaching ... Easy to Understand .... Thanks

[@SivaAcademy]

Welcome Mohit

[@kunuturuaravindreddy5879]

The way you details every minor point is top level among others I saw many concepts but your series is what I clearly understood everything thing with example 👍👍👍👍👍👍

[@SivaAcademy]

Thank you bro 🙏👍💐

[@nagarajut5934]

Thanks very much sir, Good explanation about new features easily understanding any person

[@SivaAcademy]

Thank you 💐

[@praveenreddy4507]

Really awesome, we are expecting videos on Oracle hints .

[@SivaAcademy]

Sure bro, please stay tuned

[@kondareddy2130]

your are doing a great job sir

[@SivaAcademy]

Thank you bro

[@gsraj511]

Thank you bro for your clear explanation...

[@SivaAcademy]

Welcome bro

[@manishsahu2740]

Thanks Shiva Academy! really helpful for us

[@SivaAcademy]

Welcome bro

[@rudahiya1973]

Sir your videos are best

[@rajeshnaidu9331]

Good explanation and thanks for sharing advanced topics

[@SivaAcademy]

Most welcome

[@yakaba]

Excellent video! Is there a clause that does the reverse of this?

[@yarramsettinagendra8768]

Good video sir, thanks 👍

[@SivaAcademy]

Welcome 👍

[@evenkateshraju9241]

Hello Siva, I am a great fan of your SQL/PLSQL videos. I have been trying to contact you, but with no luck. Do you have any plans to conduct a complete online course? If so, please let me know. Five others will join me.

[@Vapi786]

Sir mere ander oracle 21c ka installation roll back ho raha hai Bata raha hai ki system not modified

[@67giridhar]

Good Explanation ,Thanks Bro and God bless you, Do you have any videos on Oracle HINTs.

[@SivaAcademy]

Thank you 🙏, not yet bro, I will add to upcoming videos

[@satishch27]

Thank you Siva Academy

[@SivaAcademy]

You are welcome

[@TOOLSinspect]

Thank you from BD

[@SivaAcademy]

Welcome bro

[@rambiradar7828]

Very good videos

[@SivaAcademy]

Thank you

[@sbalajion]

Can we use returning clob clause in select when the resultset exceeds more than 4000 in size?

[@kadirappaa7949]

Try to create a table_a and populate dummy data and test. F_SUM - Custom function returning sum of values. NULLs are ignored. if both values are NULL, then returns NULL Variables used in below query: V_CDL VARCHAR2 (4000); V_CDL_AB VARCHAR2(32767); SELECT LISTAGG('SUM('||PARAM_VALUE||') '||PARAM_value, ','||CHR(10)) WITHIN GROUP(ORDER BY param_value), RTRIM(XMLAGG(XMLELEMENT(E,'A.'||PARAM_VALUE||'=F_SUM(A.'||PARAM_VALUE||',B.'||PARAM_VALUE||'),'||CHR(10)).EXTRACT('//text()') ORDER BY PARAM_VALUE).GETCLOBVAL(), ','||CHR(10)) INTO V_CDL, V_CDL_AB FROM TABLE_A Fuction used in above query: -------------------------------------------------------- -- DDL for Function F_SUM -------------------------------------------------------- CREATE OR REPLACE EDITIONABLE FUNCTION "F_SUM" (p_num_1 IN NUMBER, p_num_2 IN NUMBER) RETURN NUMBER IS BEGIN IF (p_num_1 IS NULL AND p_num_2 IS NULL) THEN RETURN NULL; ELSE RETURN NVL(p_num_1,0) + NVL(p_num_2,0); END IF; EXCEPTION WHEN OTHERS THEN RAISE; END;

[@BewithuNnk]

TQ for sharing this video. Can you Please suggest me which oracle version should be use for practice personally/ professional to learn Plsql. And 19c is there any database connectivity issues in real time.? projects.

[@rahulvermaasdf]

please share some complex oracle sql tuning session video.

[@prashantkamble8619]

Good explanation. Thanku... Can you share video link on Hints if it availabe on ur channel?

[@SivaAcademy]

thank you, will add it soon

[@shaikbasha6771]

Thanks guru...

[@SivaAcademy]

🙏💐👍

[@phaniphanidhar1736]

hi bro thanks for the video i having one problem with listagg canu helpme? i just want only unique values for only listagg column without using any distinct keyword or row_number function

[@SivaAcademy]

In the inner query you can remove the duplicate values without using DISTINCT keyword, please look into this video for more details, kzbin.info/www/bejne/aHibq6h7aq-oi6M

[@soniyas5424]

How to find distinct items in listag version 11g

[@SivaAcademy]

We need to remove duplicate in inner query, and use listagg in outer query

[@SainikaChandramohan]

Sir, Please can this video be updated with latest versions of oracle.

[@SivaAcademy]

Sure bro, please stay tuned

[@md.selimhossain4181]

select listagg(name,',' on overflow truncate ' some more value exists...' without count) within group (order by name) from tmp2 where id

[@Pmreedy801]

thank you sir

[@SivaAcademy]

Welcome bro

[@manoharanmalathi3041]

Plz make video for Unix command anna

[@kondareddy2130]

please provide full courses sir

[@SivaAcademy]

Sure, Please stay tuned bro

[@VethakaliVethuku]

Yahhh - Learned some thing new ....... (y)

[@SivaAcademy]

👍💐

[@VethakaliVethuku]

@@SivaAcademy Hey Do we have any video for Oracle Table Partitions (all partitions) ?

[@SivaAcademy]

Not yet, please stay tuned

[@ShaikAbdulFayazYCE]

okko video okko diamond

[@sourabhsinghrajpoot2505]

Partionedby is not cover

[@sahanabuvana767]

🙏

[@subhrapriyadarshini70]

Very nice and easy explanation.can u pls make vdo on difference between listaagg and xmlagg function and its usage

[@malliarjun5250]

Table columns PID timestamp status 1 10 open 1 11 close 1 12 success 1 13 fail 2 10 null 2 11 close 2 12 fail 2 13 null Output expected :- 1,open,failed 2,close,fail

[@SivaAcademy]

Yeah bro, I got your mail, will revert back the query today, please stay tuned