Update one row : UPDATE Set Clause « Insert Delete Update « Oracle PL / SQL

1. Oracle PL / SQL
2. Insert Delete Update
3. UPDATE Set Clause

Update one row

 
SQL>
SQL> CREATE TABLE project (
  2    pro_id              NUMBER(4),
  3    pro_name            VARCHAR2(40),
  4    budget          NUMBER(9,2),
  5    CONSTRAINT project_pk   PRIMARY KEY (pro_id)
  6  );

Table created.

SQL>
SQL>
SQL> INSERT INTO project(pro_id, pro_name, budget)VALUES (1001, 'A',1912000);

1 row created.

SQL> INSERT INTO project(pro_id, pro_name, budget)VALUES (1002, 'ERP',9999999);

1 row created.

SQL> INSERT INTO project(pro_id, pro_name, budget)VALUES (1003, 'SQL',897000);

1 row created.

SQL> INSERT INTO project(pro_id, pro_name, budget)VALUES (1004, 'CRM',294000);

1 row created.

SQL> INSERT INTO project(pro_id, pro_name, budget)VALUES (1005, 'VPN',415000);

1 row created.

SQL>
SQL> SET ECHO ON
SQL> UPDATE project
  2     SET budget = 1000000
  3  WHERE pro_id = 1006
  4  /

0 rows updated.

SQL>
SQL>
SQL>
SQL>
SQL> drop table project;

Table dropped.

SQL>

   
  

Related examples in the same category