I am new to writing queries, so looking to the experts for some help.
I need to add one role to all users in one database. I am obviously missing something, but not quite sure what.
Really appreciate any help.
INSERT INTO PSROLEUSER WHERE ROLENAME = 'X';
SQL Error: ORA-00926: missing VALUES keyword
00926. 00000 - "missing VALUES keyword"