Find Bind Data

10g:
SELECT sql_text, NAME, value_string, datatype_string
FROM v$sql_bind_capture
JOIN v$sql
USING (hash_value)
WHERE sql_text LIKE '%select *%';