I don't believe my eyes! I haven't expected ever to see such a
denormalized table made in relational DB... (what are we in Lotus Notes
or what?)
And splitting string in Oracle si BITCH - I haven't found easy
solution yet - only one I found is similar to already posted by Mike
well thanks for morning laughter session in here (not laughing on
author, but on the data)
hoppo
On 8. 4. 2011 18:44, ORAQ wrote:
Hi
Can some one please help me write an oracle query to get the # of
students taking a particular class.
I am using Oracel 9i
I have a table with Student_id, classes, teacher
and the values look like
111 Math;Social;Science Ms.Reed
112 Math;Science;PE Mr.Smith
113 PE;Social;Math Ms.Reed
114 Art;PE;Reading Mr.Jones
(classes taken by students are stored in one field with ; separated
values)
I want the result to display as
1.Classname and studentcount
Math 3
Science 2
Social 2
Art 1
PE 2
Reading 1
2. Classname studentcount groupedby teacher name
Math 2 Ms.Reed
Math 1 Mr.Smith
Social 2 Ms.Reed
Science 1 Mr.Smith
Science 1 Ms.Reed
PE 1 Mr.Smith
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
