Home » RDBMS Server » Server Administration » INPUT BOX COMMAND
INPUT BOX COMMAND [message #371216] Tue, 19 September 2000 07:45 Go to next message
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 Go to previous message
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
Previous Topic: converting number to ascii
Next Topic: Create a table....
Goto Forum:
  


Current Time: Thu Mar 28 07:48:35 CDT 2024