sql add varchar column code example

Example: add multiple field in table sql

ALTER TABLE employee
  ADD (
  	  last_name VARCHAR(50) NOT NULL,
      first_name VARCHAR(40) NOT NULL
      );