SQL>
SQL>
SQL> CREATE TABLE Instructor (
2 InstructorID INT NOT NULL PRIMARY KEY,
3 Name VARCHAR(50) NOT NULL);
Table created.
SQL> INSERT INTO Instructor (InstructorID,Name) VALUES (1,'Victor');
1 row created.
SQL> INSERT INTO Instructor (InstructorID,Name) VALUES (2,'Bill');
1 row created.
SQL> INSERT INTO Instructor (InstructorID,Name) VALUES (3,'Mary');
1 row created.
SQL> INSERT INTO Instructor (InstructorID,Name) VALUES (4,'Jack');
1 row created.
SQL> INSERT INTO Instructor (InstructorID,Name) VALUES (5,'Peter');
1 row created.
SQL> INSERT INTO Instructor (InstructorID,Name) VALUES (6,'Tom');
1 row created.
SQL>
SQL> CREATE OR REPLACE PROCEDURE InsertInstructor (i_ProfID IN INT,
2 i_ProfName IN VARCHAR DEFAULT 'Prof. A.N. Other')
3 AS
4 BEGIN
5 INSERT INTO Instructor (InstructorID, Name)
6 VALUES (i_ProfID, i_ProfName);
7 END;
8 /
Procedure created.
SQL>
SQL>
SQL> drop table Instructor;
Table dropped.