视图.txt

来自「很简单的小程序」· 文本 代码 · 共 4 行

create or replace view jcha(jid,jname,jtype,jsl)
as select jid,jname,jtype,jsl
from base
where jtype is not null;