DataGrid (Grid view) Question:
Download Job Interview Questions and Answers PDF
Why can not I edit the results of a query in the SQL Editor?
Answer:
Query statements MUST return the ROWID to be updatable. For example:
select * from employee where salary > 2000
would not be updatable, whereas:
select employee.*, rowid from employee where salary > 2000
would be updatable.
To reduce this obvious nuisance, you can use the TOAD-specific EDIT statement. For example:
edit employee where salary > 2000
If the resultset should be editable but remains read-only, make sure the TOAD Options > Data Grids - Data tab, Default to Read-Only Queries checkbox is NOT enabled
select * from employee where salary > 2000
would not be updatable, whereas:
select employee.*, rowid from employee where salary > 2000
would be updatable.
To reduce this obvious nuisance, you can use the TOAD-specific EDIT statement. For example:
edit employee where salary > 2000
If the resultset should be editable but remains read-only, make sure the TOAD Options > Data Grids - Data tab, Default to Read-Only Queries checkbox is NOT enabled
Download DataGrid (Grid view) Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How do you check whether the row data has been changed? | Why can not I add a new record by hitting the down arrow key in the data tab? |