Hi there.
I have a table defined as follows:
CREATE TABLE T
(emp_name VARCHAR[4],
emp_no NUMBER(5),
hire DATE);
I need to write a function (ideally in embedded SQL,
but PL will do) that will take a variable number of
emp_names and variable number of emp_nos and return
all rows in the table that have any of the emp_names
or emp_nos. I am pretty good with simple SQL queries
but am new to PL/SQL, and would most appreciate any
help (the Oracle manuals seems to muddy the waters if
anything).
Much appreciated,
Ronnie
Received on Wed Jul 22 1998 - 19:14:44 CDT
