All geek questions in one place

Oracle sql developer edit fields

I recently tried the oracle sql-developer 2.11 and 3 EA 2 and 32-bit windows (although I also tried 2.11 64-bit). One of the problems that made me wonder is viewing the data. It seems I can’t edit the data in the fields directly from the MYSQL database, but I can manipulate the data through SQL, so this is not a permissions issue.

Can someone tell me how to enable it so that I can click on the fields and edit, I am sure that this is possible if you look at the video on YouTube, however these are demonstrations with an oracle, so I wonder if this is a limitation with using mysql? Is anyone

PS Also has the same issue with MS Access Database.

+4
source share
1 answer

I think this is a limitation.

Oracle tables have a built-in ROWID that is unique to any record in the table. Thus, the data browser can pull out a ROWID for each row displayed. When you change the "pet" column from "CAT" to "DOG", it just generates a table UPDATE SET PET = "DOG" WHERE ROWID = ....

There are several problems with this (e.g., fine-grained access control tables / row level security), so it does not always work even for Oracle tables.

Technically, an equivalent can be made by defining the primary key columns, but this requires that the primary key be involved in the table, therefore excluding updated views. And then the problem arises of determining which columns are the primary key, and using these values ​​(data types, etc.). In short, this is a lot of extra work under the hood, the entire database, so I'm not surprised that the functionality has not been developed.

+3
source

Source: https://habr.com/ru/post/1333078/

More articles:


All Articles