| INPUT BOX COMMAND [message #371216] |
Tue, 19 September 2000 07:45  |
Mohsan Iqtadar
Messages: 1
Registered: September 2000
|
Junior Member |
|
|
i have 4 tables STUDENT, ENROLMENT, COURSE, AND COURSE_ORGANISER
i need to know about an sql command that allows me to input a student id from STUDENT TABLE and display the students name from STUDNET TABLE and the name of course from COURSE TABLE.
Please can anyone help.....
|
|
|
|
| Re: INPUT BOX COMMAND [message #371226 is a reply to message #371216] |
Wed, 20 September 2000 05:56  |
Andreas Pollmeier
Messages: 7
Registered: February 2000
|
Junior Member |
|
|
Your SQL-Script could look like this:
undef v_student_id
accept v_student_id number prompt 'Student-ID: ';
select student_name from student
where student_id=&v_student_id;
...
Andreas
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
