-
Thanks for your reply James.
But in your example you know the columns that a being passed to the procedure.
I need to have a generic where clause, meaning I don't know the number of columns or which columns will be passed to the procedure.
In other words, a user will be passing a string that can have different columns and values.
Here are the examples of something a user can pass.
'commission is null'
'empno = 4 and deptno = 10'
'empname = 'SMITH''
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|