WORKAROUND 1:
Write the sentences with PL/SQL in the SQL Editor
1. Select 'Edit|SQL Editor'
2. Write the UPDATE or INSERT sentence. For example:
INSERT INTO table (column1, column2, ..., column_n)
VALUES (expression1, expression2, ..., expression_n)
UPDATE table
SET column1 = expression1,
column2 = expression2,
...
column_n = expression_n
[WHERE conditions]
Note: WHERE conditions is optional
WORKAROUND 2:
Use the Generate SQL feature of Toad Data Point
1. Right click the table to be modified | Generate SQL | Insert Statement | To Editor
or
Right click the table to be modified | Generate SQL | Update Statement | To Editor
2. Specify each value to be inserted or modified