Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: cursor parameter and SQL WHERE clause
Try:
CURSOR c1(p_in) IS
SELECT *
FROM tab1
WHERE col1 LIKE p_in||'%';
--
Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk
Received on Sat Jun 19 1999 - 03:39:53 CDT