10654Re: [PkOug] Need Query
- Nov 9, 2013Listagg is only used in oracle 11ghere is the tested query on oracle 10g 100% fine.
select deptno, rtrim (xmlagg (xmlelement (e, ename || ',')).extract ('//text()'), ',') enames from emp group by deptno
Associate Technical Consultant.
On Friday, November 8, 2013 12:22 AM, Badruddin Hunzai <badarhunzai@...> wrote:
Dear Tahir,It's a very simple query. You need to join both tables.SELECTstudent_reg_no,course_idFROMStudent s,Course cWHEREc. student_reg_no=s. student_reg_no;Good luck.Badar
On Wednesday, November 6, 2013 4:26 PM, Majid Tahir <tahir.majid@...> wrote:
how can i write this query, kindly helpstudent_reg_no course idlikeI need a query to represent the course in single coulumnsstudent_reg_no course idtable coursetahir 2ali 1table student:I have following tablesAOA,Dear Members,
- << Previous post in topic Next post in topic >>