Table Definitions for Row Returning Examples
The table definitions that follow are required for the following examples:
drop table emp_rowproc_table;
create table emp_rowproc_table
( name CHAR(10),
salary FLOAT,
dept CHAR(8),
div CHAR(3),
mgr CHAR(10),
birthdate CHAR(25),
num_dep FLOAT);
INSERT INTO emp_rowproc_table ( name, salary, dept, div, mgr, birthdate, num_dep)
VALUES ('Kieran', 50000, 'sales', 'NE', 'Verducci', '12-mar-1947',2);
INSERT INTO emp_rowproc_table ( name, salary, dept, div, mgr, birthdate, num_dep)
VALUES
('Gordon ', 27000.00,
'tech sup', 'NC ', 'Shigio ', '23-may-1963 ', 0);
INSERT INTO emp_rowproc_table ( name, salary, dept, div, mgr, birthdate, num_dep)
VALUES
('Green ', 26000.00,
'market ', 'NW ', 'McTigue ', '19-dec-1961 ', 0);
INSERT INTO emp_rowproc_table ( name, salary, dept, div, mgr, birthdate, num_dep)
VALUES
('Gregori ', 31000.00,
'sales ', 'NW ', 'Verducci ', '21-oct-1949 ', 2);
INSERT INTO emp_rowproc_table ( name, salary, dept, div, mgr, birthdate, num_dep)
VALUES
('Huber ', 32000.00,
'sales ', 'NC ', 'Clark ', '29-jun-1951 ', 2);
INSERT INTO emp_rowproc_table ( name, salary, dept, div, mgr, birthdate, num_dep)
VALUES
('Kay ', 38000.00,
'sales ', 'NC ', 'Clark ', '12-mar-1944 ', 3);
INSERT INTO emp_rowproc_table ( name, salary, dept, div, mgr, birthdate, num_dep)
VALUES
('Kreseski ', 24000.00,
'tech sup', 'NC ', 'Shigio ', '11-sep-1955 ', 0);
INSERT INTO emp_rowproc_table ( name, salary, dept, div, mgr, birthdate, num_dep)
VALUES
('Mandic ', 43000.00,
'sales ', 'SE ', 'Verducci ', '10-jul-1964 ', 0);
INSERT INTO emp_rowproc_table ( name, salary, dept, div, mgr, birthdate, num_dep)
VALUES
('McShane ', 22000.00,
'admin ', 'NW ', 'Clark ', ' 3-mar-1943 ', 0);
INSERT INTO emp_rowproc_table ( name, salary, dept, div, mgr, birthdate, num_dep)
VALUES
('McTigue ', 41000.00,
'sales ', 'NW ', 'Verducci ', ' 9-apr-1953 ', 1);
INSERT INTO emp_rowproc_table ( name, salary, dept, div, mgr, birthdate, num_dep)
VALUES
('Ming ', 22000.00,
'tech sup', 'SE ', 'Shigio ', ' 4-may-1956 ', 1);
INSERT INTO emp_rowproc_table ( name, salary, dept, div, mgr, birthdate, num_dep)
VALUES
('Ramos ', 30000.00,
'tech sup', 'NW ', 'Shigio ', '21-jan-1941 ', 0);
INSERT INTO emp_rowproc_table ( name, salary, dept, div, mgr, birthdate, num_dep)
VALUES
('Robinson ', 80000.00,
'sales ', 'NE ', 'Verducci ', '20-nov-1952 ', 1);
INSERT INTO emp_rowproc_table ( name, salary, dept, div, mgr, birthdate, num_dep)
VALUES
('Sabel ', 21000.00,
'tech sup', 'SE ', 'Shigio ', ' 8-jan-1958 ', 0);
INSERT INTO emp_rowproc_table ( name, salary, dept, div, mgr, birthdate, num_dep)
VALUES
('Saxena ', 22000.00,
'tech sup', 'NC ', 'Shigio ', ' 8-may-1950 ', 0);