Mega Code Archive

 

Categories / Oracle PLSQL / Insert Delete Update

 

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>