Oracle Database case study-failed to execute Oracle script or exception-string parameters in SQL commands use double quotation marks, leading to database table information update failure

1.1 symptom description when an SQL command containing double quotation marks is executed to update the data table information, the system displays the following error message:
For example:
SQL> update group_table set grouppswd = "adbaadadf" where groupname = 'sms ';

ORA-00904: "adbaadadf": invalid identifier

1.2 possible cause: Double quotation marks are used for string parameters in SQL commands. single quotation marks are used. 1.3 Procedure OracleThe machine on which the user logs on to the database. To SysdbaThe user connects to the database.

% Sqlplus/as sysdba

Change the double quotation marks in the original SQL command to single quotation marks, and then execute the modified command to update the data table information.

SQL> update group_table set grouppswd = 'adadadw' where groupname = 'ms ';

Update successful. The system displays the following information:

1 row updated.