This article provides an example to view records of student, course and SC tables.
Select * form student; ROLLNO NAME CLASS BIRTHDATE ---------- -------------- ---------- --------- 1 Mikki Raval A 20-MAR-84 2 Sumeet Patel A 10-SEP-87 3 Deepa Jani A 12-MAR-79 4 Mona Amin B 08-APR-81 5 Tikku Thakkar B 15-DEC-82 Select * from course; COURSENO COURSENAME MAX_MARKS PASS_MARKS ---------- -------------- ---------- ---------- 610001 FOP 100 35 610002 Accounting 100 35 610003 Maths 100 35 610004 DBMS 100 35 610005 Computer Graphics 100 35 Select * from sc; ROLLNO COURSENO MARKS ---------- ---------- ---------- 1 610001 82 1 610002 80 1 610003 77 1 610004 72 1 610005 80 2 610001 90 2 610002 88 2 610003 77 2 610004 60 2 610005 78 3 610005 87 3 610001 78 3 610002 67 3 610003 89 3 610004 78 3 610005 78 4 610001 75 4 610002 45 4 610003 58 4 610004 68 4 610005 78 5 610001 70 5 610002 78 5 610003 52 5 610004 79 5 610005 85