Oracle SQL Practical question with answer | Reverse the String without using reverse function

[@fkrockerzz91]

Hi Siva, Your videos are really helpful. Thank you!

[@SivaAcademy]

Thanks bro

[@amitajhariya9521]

Sir, can you please let me know, how can display emp name with comma separated value partition by dep id

[@dipaksonawane9380]

Select listagg(emp_name,''') within group(order by dept_id) from emp

[@dipaksonawane9380]

Use this query

[@sanjeetkumar-nk8ms]

Hi Siva, i have a question. We have a table T1 with 2 column (empid,name)and t2 with 4 columns(empid1,name1,empid2,name2) table T1 ia having 1001 records . data in table is srted on empid,we need to move data from T1 to T2 and logic is 1st and last record from T1 will go to first record of T2,2nd and 2nd last record from T1 will go to 2nd record of T2 and so on. Write sql code to achieve the desired data movement from T1 to T2. Request to please provide video asap. Thanks in advance .

[@SivaAcademy]

@sanjeet, I got your question, will post as soon as possible... Stay tuned

[@shaheenshaikh6701]

Sir what is connect by level plz explain

[@SivaAcademy]

@Shaheen, connect by clause is used to write queries where ever there is hierarchical related data exists in the table, I will post a video on hierarchical queries soon, please stay tuned

[@sivanagarajugummadilli]

In 21c: SELECT LISTAGG(A) FROM ( SELECT SUBSTR('SIVA',-LEVEL,1) A FROM DUAL CONNECT BY LEVEL

[@enjoyfriends873]

Thanks SELECT listagg(substr(s, - ROWNUM, 1)) AS dt FROM ( SELECT 'WELCOME' AS s FROM dual ) CONNECT BY level