想问几条语句的功能,见帖子程序段
想问几条语句的功能,见下面的程序段
1.
select max(account_desc) into account_desc_ from voucher where account = account_;
这条语句的功能。
2.
values ('A'||account_ ,
account_ ,
account_desc_,
sfromdate_,
'',
'',
0,0,0,0,0,0,0,
get_qc(com_,'SL',account_,sfromdate_ ,tjflag_),
0,
get_qc(com_,'YE',account_,sfromdate_,tjflag_),
Zt_com_,
'',
'',
sysdate
);
这一段中的“values ”代表的是变量吗,后面的()中的功能是啥,“''”代表的是不是空字段,“'A'||account_ ,”这一句的功能是啥?
谢谢。
begin
if account_ is not null then
select com_api.Get_Name(User_Access_API.Get_User_Com_Id) into Zt_com_ from dual;
select max(account_desc) into account_desc_ from voucher where account = account_;
insert into F_TEMP_TAB (
id,
account,
account_desc,
voucher_date,
voucher_no,
voucher_desc,
debet_sl,
debet_dj,
debet_kj,
debet_yzf,
credit_sl,
credit_dj,
credit_amount,
balance_sl,
balance_dj,
balance_je,
bz1,
bz2,
bz3,
rowversion)
values ('A'||account_ ,
account_ ,
account_desc_,
sfromdate_,
'',
'',
0,0,0,0,0,0,0,
get_qc(com_,'SL',account_,sfdate_ ,tjfl_),
0,
get_qc(com_,'YE',account_,sfdate_,tjfl_),
Zt_com_,
'',
'',
sysdate
);
想问几条语句的功能,见下面的程序段
1.
select max(account_desc) into account_desc_ from voucher where account = account_;
这条语句的功能。
2.
values ('A'||account_ ,
account_ ,
account_desc_,
sfromdate_,
'',
'',
0,0,0,0,0,0,0,
get_qc(com_,'SL',account_,sfromdate_ ,tjflag_),
0,
get_qc(com_,'YE',account_,sfromdate_,tjflag_),
Zt_com_,
'',
'',
sysdate
);
这一段中的“values ”代表的是变量吗,后面的()中的功能是啥,“''”代表的是不是空字段,“'A'||account_ ,”这一句的功能是啥?
谢谢。
begin
if account_ is not null then
select com_api.Get_Name(User_Access_API.Get_User_Com_Id) into Zt_com_ from dual;
select max(account_desc) into account_desc_ from voucher where account = account_;
insert into F_TEMP_TAB (
id,
account,
account_desc,
voucher_date,
voucher_no,
voucher_desc,
debet_sl,
debet_dj,
debet_kj,
debet_yzf,
credit_sl,
credit_dj,
credit_amount,
balance_sl,
balance_dj,
balance_je,
bz1,
bz2,
bz3,
rowversion)
values ('A'||account_ ,
account_ ,
account_desc_,
sfromdate_,
'',
'',
0,0,0,0,0,0,0,
get_qc(com_,'SL',account_,sfdate_ ,tjfl_),
0,
get_qc(com_,'YE',account_,sfdate_,tjfl_),
Zt_com_,
'',
'',
sysdate
);
select max(account_desc) into account_desc_ from voucher where account = account_;
这条语句的功能。
符合条件的记录,可能多条,中最大的account_desc
INTO是过程中的赋值
values(值1,值2,。。)
这个是插入语法“''”代表的是不是空字段,--是的
“'A' ¦ ¦account_ ,”这一句的功能是啥? -- ||是连接,account_ 前面加上 'A'
比如 account_ = ‘暗示’ ,哪么这个含义就是 ‘A暗示’