In Oracle/PLSQL, the trunc function returns a date truncated to a specific unit of measure. The syntax for the trunc function is: trunc ( date, [ format ] ) date is the date to truncate. forma
NUMBER类型细讲: Oracle number datatype 语法:NUMBER[(precision [, scale])] 简称:precision --> p scale --> s
DROP PROCEDURE MRR.delete_risk_assessment; CREATE OR REPLACE PROCEDURE MRR.delete_risk_assessment ( id IN NUMERIC ) IS BEGIN DELETE
基本结构 CREATE OR REPLACEPROCEDURE 存储过程名字 ( 参数1 IN NUMBER, 参数2 IN NUMBER ) IS 变量1 INTEGER :=0; 变量2 DATE; BEGIN END 存储过程名字 ---查询数据 并返回一个列表 DROP PROCEDURE
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号