Good afternoon, a doubt to make an update of a value in a table is necessary to do it through a query with the Update instruction or can it be done directly in the table as if it were an excel?
Excuse my ignorance I'm new to this
Good afternoon, a doubt to make an update of a value in a table is necessary to do it through a query with the Update instruction or can it be done directly in the table as if it were an excel?
Excuse my ignorance I'm new to this
It can be done as if it were an Excel, it is advisable to do it through an query of update .
In Toad:
Schema Browser > Tablas > (mi_tabla) > Data (Pestaña)
Query:
UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;
Pd. Do not forget to commit.