格式:
insert into 表名
eg:
create or replace
PROCEDURE SAVE_USER
(
U_NO IN VARCHAR2
, U_ACCOUNT IN VARCHAR2
, U_PWD IN VARCHAR2
, U_NAME IN VARCHAR2
, U_NICKNAME IN VARCHAR2
, U_CR_TIME IN timestamp
, U_STATUS IN VARCHAR2
, REMARK IN VARCHAR2
, STATUS IN VARCHAR2
) AS
BEGIN
insert into t_sys_user(
U_ID,U_NO,U_ACCOUNT,U_PWD,U_NAME,U_NICKNAME
,U_CR_TIME,U_STATUS,REMARK,STATUS)
values(S_T_SYS_USER.nextval,
U_NO,U_ACCOUNT,U_PWD,U_NAME,U_NICKNAME,U_CR_TIME,U_STATUS,REMARK,STATUS
);
END SAVE_USER;
insert into 表名
eg:
create or replace
PROCEDURE SAVE_USER
(
U_NO IN VARCHAR2
, U_ACCOUNT IN VARCHAR2
, U_PWD IN VARCHAR2
, U_NAME IN VARCHAR2
, U_NICKNAME IN VARCHAR2
, U_CR_TIME IN timestamp
, U_STATUS IN VARCHAR2
, REMARK IN VARCHAR2
, STATUS IN VARCHAR2
) AS
BEGIN
insert into t_sys_user(
U_ID,U_NO,U_ACCOUNT,U_PWD,U_NAME,U_NICKNAME
,U_CR_TIME,U_STATUS,REMARK,STATUS)
values(S_T_SYS_USER.nextval,
U_NO,U_ACCOUNT,U_PWD,U_NAME,U_NICKNAME,U_CR_TIME,U_STATUS,REMARK,STATUS
);
END SAVE_USER;