存出
ORACLEPLSQL插入或更新数据的几种方式
ORACLEPLSQL插⼊或更新数据的⼏种⽅式第⼀种,直接⽤values 插⼊---⽇期需要⽤TO_DATE操作INSERT INTO EMP (EMPNO,ENAME ,JOB,MGR, HIREDATE , SAL ,COMM, DEPTNO) VALUES(1122,'STEVE','⼯⼈',2233,TO_DATE('2017-01-03','YYYY-MM-DD'),3000,500,2...
ORACLEPLSQL插⼊或更新数据的⼏种⽅式第⼀种,直接⽤values 插⼊---⽇期需要⽤TO_DATE操作INSERT INTO EMP (EMPNO,ENAME ,JOB,MGR, HIREDATE , SAL ,COMM, DEPTNO) VALUES(1122,'STEVE','⼯⼈',2233,TO_DATE('2017-01-03','YYYY-MM-DD'),3000,500,2...