sql-mysql

[sudheer.p...@gmail.com]

hi
I have subjects table like this

CREATE TABLE IF NOT EXISTS `subjects` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`code` varchar(255) DEFAULT NULL,
`typename` varchar(255) DEFAULT NULL,
`status` varchar(255) DEFAULT NULL,
`credits` int(11) DEFAULT NULL,
`max_external_marks` int(11) DEFAULT NULL,
`max_internal_marks` int(11) DEFAULT NULL,
`max_assignment_marks` int(11) DEFAULT NULL,
`max_sessional_marks` int(11) DEFAULT NULL,
`periods_in_week` int(11) DEFAULT NULL,
`continuous_periods` int(11) DEFAULT NULL,
`year` date DEFAULT NULL,
`selected_terms` varchar(255) DEFAULT NULL,
`select_semester` varchar(255) DEFAULT NULL,
`available_instructers` varchar(255) DEFAULT NULL,
`selected_instructers` varchar(255) DEFAULT NULL,
`csv_file_name` varchar(255) DEFAULT NULL,
`semester_id` int(11) DEFAULT NULL,
`department_id` int(11) DEFAULT NULL,
`organization_id` int(11) DEFAULT NULL,
`division_id` int(11) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=69 ;

it is having some data in it

now I want display like

Student_id subject(1) subject(2) subject(3)
460 12 17 19

[Mladen Gogala]

On Wed, 03 Oct 2012 01:26:52 -0700, sudheer.puthineedi wrote:

> hi I have subjects table like this

.....

> ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=69 ;
>
> it is having some data in it
>
> now I want display like
>
> Student_id subject(1) subject(2) subject(3)
> 460 12 17 19

The answer is really simple. What you need is Oracle EE 11.2.0.3 RAC
where you can use Apex to get what you need.



--
Mladen Gogala
The Oracle Whisperer
http://mgogala.byethost5.com