DataGrid (Grid view) Question:
Download Questions 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

Download DataGrid (Grid view) Interview Questions And Answers PDF

Previous QuestionNext 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?