Yurttas/PL/DBL/oracle/F/01/SPJ/Suppliers-ins.sql
Jump to navigation
Jump to search
1REM
2REM
3REM Suppliers-ins.sql
4REM
5REM
6
7INSERT INTO Suppliers
8 VALUES ('S01', 'Frank', 20, 'Houston');
9
10INSERT INTO Suppliers
11 VALUES ('S02', 'David', 20, 'Houston');
12
13INSERT INTO Suppliers
14 VALUES ('S03', 'David', 30, 'Houston');
15
16INSERT INTO Suppliers
17 VALUES ('S04', 'Jason', 10, 'Denver');
18
19INSERT INTO Suppliers
20 VALUES ('S05', 'Richard', 30, 'Denver');
21
22 INSERT INTO Suppliers
23 VALUES ('S06', 'Carlos', 20, 'Phoenix');
24
25INSERT INTO Suppliers
26 VALUES ('S07', 'John', 40, 'Phoenix');
27
28INSERT INTO Suppliers
29 VALUES ('S08', 'Ajay', 30, 'Detroit');