I have an Interactive Grid with fullname of employee (sometimes it is also mixed with login info) like this it is on view v_user_roles:
Smith Adam / smitha
Livingstone Mary
I tried to filter it in sql workshop→ sql commands:
SELECT substr(user_display_name, 1, instr(user_display_name, ' ') - 1) FROM v_user_roles;
SELECT LTRIM(REGEXP_REPLACE(REGEXP_REPLACE(user_display_name, '/.*$', ''), '^[^ ]+', '')) FROM v_user_roles;
It works there just fine. But then I tried to add appropriate column Nazwisko with Source → SQL expression I got message:
ORA-20999: Failed to parse SQL query! ORA-06550: line 3, column 23: ORA-00907: missing right parenthesis
What can I do to fix it?
Thank you