view

INSERT INTO t_sys_dict(id, name, code, pid, remark, seq, type, lv)
SELECT id, name, code, pid, remark, seq, state, lv FROM t_sys_org;



COMMIT;






CREATE TABLE zwf_01
(
	a VARCHAR2(100),
	b VARCHAR2(100)
);

INSERT INTO zwf_01 VALUES('1', '2');

CREATE TABLE zwf_02
(
	a VARCHAR2(100),
	c VARCHAR2(100)
);

INSERT INTO zwf_02 VALUES('1', '2');





CREATE OR REPLACE VIEW v_zwf_test
(
	x1,
	x2,
	x3
)
AS
SELECT
	t1.a,
	t1.b,
	t2.c
FROM zwf_01 t1, zwf_02 t2 WHERE t1.a = t2.a;