Problem with pl/sql report

Expand Post »

Hi there!

Ive been working on my relational schema for a while now and just recently managed to implement it. I wanted experiment a little with it so ive decided to produce a report displaying relevant information. At the moment my schema only consists of 3 tables : a 'student' table, a 'course' table and a student 'next-of-kin' table. The pk for student is named 'studentNo', the same goes for 'course' and 'next-of-kin' ('courseNo', 'next_of_kinNo'). 10 entries have been made so far for both 'student' and 'next_of_kin'.

The report i intend to produce will need to display a list of students studying 1 common course (Business Studies, courseNo : '12885545'). The report should be ordered by studentNo.

This is what i have already come up with:

Oracle Syntax (Toggle Plain Text)
--set echo off
--set pagesize 24
--set feedback off
--set linesize 78
col A format 99999999 heading 'Student No'
col B format A15 heading 'Student Name'
col C format A15 heading 'Course Name'
col D format 99999999 'Course No'
col E format A10 heading 'Next-of-Kin'
break ON A skip 1 ON B
TTitle 'Business Studies 1 Option BT300'
BTitle 'Prepared By : Richard Stroud / 20527796'
SELECT StudentNo A,
fName || ' ' || lName B,
title C,
courseNo D,
fName || ' ' || lName E,
 
FROM student A, course B, next_of_kin C
WHERE B.courseNo = 12885545
ORDER BY studentNo
--clear columns
--TTitle off
--BTitle off
--set feedback on
--set pagesize 24
--clear breaks
--set echo off
--set pagesize 24
--set feedback off
--set linesize 78
col A format 99999999 heading 'Student No'
col B format A15 heading 'Student Name'
col C format A15 heading 'Course Name'
col D format 99999999 'Course No'
col E format A10 heading 'Next-of-Kin'
break on A skip 1 on B
TTitle 'Business Studies 1 Option BT300'
BTitle 'Prepared By : Richard Stroud / 20527796'
Select StudentNo A,
fName || ' ' || lName B,
title C,
courseNo D,
fName || ' ' || lName E,

From student A, course B, next_of_kin C
where B.courseNo = 12885545
order by studentNo
--clear columns
--TTitle off
--BTitle off
--set feedback on
--set pagesize 24
--clear breaks

When i execute the above i am prompted with an 'unknown column option "Course" error message.

I will greatly appreciate any help in regards to this issue

~ Richard

Last edited by peter_budo; Nov 18th, 2008 at 6:54 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

Similar Threads

MySQL installation problem in Linux Applications and Software
Crystal report in VB.NET
SQL writer hangs and causes vista to restart in Windows Vista and Windows 7
Need urgent help. Problem with SQL and win server. in Windows NT / 2000 / XP
SQL Report Help in MS SQL

rich_da_prog

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Oct 2006

Permalink

Nov 20th, 2008

Re: Problem with pl/sql report

why using same alias for the table name and column name ?

debasisdas

Featured Poster

Reputation Points: 665

Solved Threads: 427

Posting Genius

Offline

6,406 posts
since Feb 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Oracle Forum Timeline: how do I nest a CASE statement in an INNER JOIN

Next Thread in Oracle Forum Timeline: join in oracle

DaniWeb Message

Cancel Changes

User Name
Password