快速执行sql文件

1、cmd远程连接数据库
sqlplus xx/密码@IP:端口号/orcl
2、@sql文件路径
例如：@C:\Users\lenovo\Desktop\001.sql
sql文件要这样写：
insert into pub_page_templet(pk_page_templet,appcode,clazz,code,creationtime,creator,dr,headcode,isdefault,metaid,modifiedtime,modifier,name,pagecode,parentid,pk_group,pk_org,resid,resmodule,templetdesc,ts)
values('0001ZZZZ5babedfea8fe','H5830150','nc.vo.jzvat.jzobl10.AggOblBillVO','H5830150_CARD',null,'~',0,'card_head','N',null,null,'~','跨区涉税报告报验卡片','H5830150_CARD','root',null,null,null,null,'跨区涉税报告报验卡片页面','2021-05-18 10:29:06');
commit;