Update number type column
SQL> CREATE TABLE customers
2 (
3 id NUMBER,
4 credit_limit NUMBER,
5 email VARCHAR2(30)
6 );
Table created.
SQL>
SQL> update customers
2 set credit_limit = 20000
3 where id = 28983;
0 rows updated.
SQL>
SQL> select id, credit_limit
2 from customers
3 where id = 28983;
no rows selected
SQL>
SQL>
SQL>
SQL> drop table customers;
Table dropped.
SQL>
Related examples in the same category