title: How to update all rows from Salary Column in Employee table?Below is my code
body: <p>I want to update all employee salary using <strong>PL/SQL oracle</strong>.Here is my code. </p>
  
  <pre><code>DECLARE 
             c_id customers.id%type; 
             c_sal  customers.salary%type; 
          BEGIN 
         SELECT  salary  
         INTO  c_sal 
         FROM customers; 
  
         IF (c_sal &lt;= 6500) THEN 
            UPDATE customers  
            SET salary =  salary + 1000;
  
  
            dbms_output.put_line ('Salary updated'); 
         END IF; 
  
      END; 
      /
  </code></pre>
  
  <p>So here is the Employee Table:</p>
  
  <p>select * from customers;</p>
  
  <pre><code>ID  NAME     AGE    ADDRESS                     SALARY
  1   Ramesh   32     Ahmedabad                   3000
  2   Khilan   25     Delhi                       1500
  3   kaushik  23     Kota                        2000
  4   Chaitali 25     Mumbai                      6500
  5   Hardik   27     Bhopal                      8500
  6   Komal    22     MP                          4500
  </code></pre>