Untitled

 avatar
unknown
plain_text
4 months ago
379 B
3
Indexable
CREATE TABLE employee (
emp_id INT PRIMARY KEY,
  emp_name VARCHAR (50),
  emp_salary INT 
);
INSERT INTO employee(emp_id,emp_name,emp_salary) VALUES (101, 'Alice', 50000);
INSERT INTO employee(emp_id,emp_name,emp_salary) VALUES (102, 'Bob', 50000);


CREATE OR REPLACE PROCEDURE update_salary(
p_emp_id IN INT ,
  p_increment IN INT ,

) AS 
BEGIN
UPDATE employee
Editor is loading...
Leave a Comment