Toad Add/Insert and Delete records Button Disabled

oracle button toad disabled-control
Attilah picture Attilah · Sep 25, 2009 · Viewed 15.4k times · Source

I'm using Toad 8.6 and when I try to add new records using the Schema Browser, Data tab, my 'insert record' is grayed out. So, I installed the 9.6 version and the same problem persists.

See the grayed out buttons in red in the picture.

enter image description here

I'm able to add records through the SQL insert statement at the SQL Editor of Toad.

How can I solve this?

Answer

asgeo1 picture asgeo1 · Sep 25, 2009

Do you mean the + button that displays at the top of the SQL results grid?

There is an "edit grid" button which you're supposed to click first to then enable changes to the data grid. Otherwise the results grid is read-only.

Related questions

Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More
How do I limit the number of rows returned by an Oracle query after ordering?

Is there a way to make an Oracle query behave like it contains a MySQL limit clause? In MySQL, I can do this: select * from sometable order by name limit 20,10 to get the 21st to the 30th rows (skip the …

Read More
ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try …

Read More