The path to oracle Learning (6) two practical examples, the path to oracle

The path to oracle Learning (6) two practical examples, the path to oracle
1. Simple data insertion example

-- Created on 2015/6/15 by LYH declare v_fnumber varchar2 (10): = 'qw'; v_fname varchar2 (10): = 'lyh'; v_fage int: = 10; v_fsalary int: = 101.00; begin insert into t_employee (fnumber, fname, fage, fsalary) VALUES (v_fnumber, v_fname, v_fage, v_fsalary); COMMIT; end;

2. Simple data deletion example

-- Created on 2015/6/15 by LYH declare v_fnumber varchar2 (10): = 'asd '; v_fname varchar2 (10): = 'gqy'; v_fage int: = 12; v_salary int: = 13; begin delete from t_employee WHERE fname = 'lyh'; COMMIT; end;

3. An example of Modification

-- Created on 2015/6/15 by LYH declare v_fnumber varchar2 (10): = 'gqy'; v_fname varchar2 (10): = 'gqy'; v_fage int: = '12'; v_fsalary int: = '20140901'; begin UPDATE t_employee SET fnumber = v_fnumber, fname = v_fname, fage = v_fage, fsalary = v_fsalary WHERE fnumber = '20160901'; end;