- 浏览: 52831 次
- 性别:
- 来自: 北京
-
最新评论
create or replace function Fun_getinvclPK( cinvclasscode varchar2,cinvclasslev number)
return varchar2 is
fpk_invcl varchar(200) := '';
invclass_code varchar(20):='';
invclass_lev number :=0;
begin
invclass_code := trim(cinvclasscode);
invclass_code := substr(invclass_code,0,length(invclass_code)-2);
invclass_lev := cinvclasslev-1;
select pk_invcl into fpk_invcl from bd_invcl where invclasscode like invclass_code||'%' and invclasslev = invclass_lev;
return fpk_invcl;
end;
create or replace function Fun_getinvclInfo( cinvclasscode varchar2,cinvclasslev number)
return varchar2 is
fpk_invcl varchar(200) := '';
invclass_code varchar(20):='';
invclass_lev number :=0;
begin
invclass_code := trim(cinvclasscode);
invclass_code := substr(invclass_code,0,length(invclass_code)-2);
invclass_lev := cinvclasslev-1;
select pk_invcl into fpk_invcl from bd_invcl where invclasscode like invclass_code||'%' and invclasslev = invclass_lev;
select invclasscode into xx from bd_invcl where bd_invcl.pk_invcl = fpk_invcl;
return fpk_invcl;
end;
create or replace function f1(pk bd_corp.pk_corp%type) return bd_corp.unitcode%type
as
v_unitcode bd_corp.unitcode%type;
begin
select unitcode into v_unitcode from bd_corp where pk_corp=pk;
return v_unitcode;
end;
create or replace function Fun_getRInfo( cpkcorp varchar2,cflag number,cpk varchar2)
return varchar2 is
rinfo varchar(200) := '';
pkcorp varchar(20):='';
pk varchar(20):='';
flag number :=0;
begin
pkcorp := trim(cpkcorp);
flag := cflag;
pk := cpk;
--公司
if (flag = 0) then
select unitcode into rinfo from bd_corp where pk_corp=pkcorp and nvl(dr,0)=0;
end if;
if (flag = 1) then
select unitname into rinfo from bd_corp where pk_corp=pkcorp and nvl(dr,0)=0;
end if;
--商品分类
if (flag = 3) then
select invclasscode into rinfo from bd_invcl where pk_corp=pkcorp and nvl(dr,0)=0 and pk_invcl = pk;
end if;
return rinfo;
end;
select Fun_getRInfo('1114',5,'') aa ,Fun_getRInfo('1004',1,'') bb from dual;
select * from bd_invcl
create or replace function Fun_getRInfo( cpkcorp varchar2,cflag number,cpk varchar2)
return varchar2 is
rinfo varchar(200) := '';
pkcorp varchar(20):='';
pk varchar(20):='';
flag number :=0;
begin
pkcorp := trim(cpkcorp);
flag := cflag;
pk := cpk;
--公司编码
if (flag = 0) then
if (pkcorp=='0001') then
unitcode='0001'
else
select unitcode into rinfo from bd_corp where pk_corp=pkcorp and nvl(dr,0)=0;
end if;
end if;
--公司名称
if (flag = 1) then
if (pkcorp=='0001') then
unitcode='0001'
else
select unitname into rinfo from bd_corp where pk_corp=pkcorp and nvl(dr,0)=0;
end if;
end if;
--商品分类编码
if (flag = 2) then
select invclasscode into rinfo from bd_invcl where nvl(dr,0)=0 and pk_invcl = pk;
end if;
--商品分类名称
if (flag = 3) then
select invclassname into rinfo from bd_invcl where nvl(dr,0)=0 and pk_invcl = pk;
end if;
--主计量单位编码
if (flag = 4) then
select shortname into rinfo from bd_measdoc where nvl(dr,0)=0 and pk_measdoc = pk;
end if;
--主计量单位名称
if (flag = 5) then
select measname into rinfo from bd_measdoc where nvl(dr,0)=0 and pk_measdoc = pk;
end if;
--自定义项档案列表名称
if (flag = 6) then
select doclistname into rinfo from bd_defdoclist where nvl(dr,0)=0 and pk_defdoclist = pk;
end if;
--自定义项档案列表编码
if (flag = 7) then
select doclistcode into rinfo from bd_defdoclist where nvl(dr,0)=0 and pk_defdoclist = pk;
end if;
--基础数据资源表名称
if (flag = 6) then
select bdname into rinfo from bd_bdinfo where nvl(dr,0)=0 and pk_bdinfo= pk;
end if;
--基础数据资源表编码
if (flag = 7) then
select bdcode into rinfo from bd_bdinfo where nvl(dr,0)=0 and pk_bdinfo= pk;
end if;
return rinfo;
end;
--商品税率
create or replace function Fun_gettptaxiInfo(ctypetaxitempk varchar2,cinvclpk varchar2,cflag number)
return varchar2 is typettinfo varchar(200) :='';
cfpk varchar2(20):='';
cinvpk varchar2(20):='';
flag number :=0;
begin
cfpk:=ctypetaxitempk;
cinvpk:=cinvclpk;
flag:=cflag;
if(flag=0) then
select unitcode into typettinfo from bd_corp where pk_corp=(select pk_corp from zm_typetaxitem_h where pk_typetaxitem_h=cfpk and nvl(dr,0)=0) and nvl(dr,0)=0;
end if;
if(flag=1) then
select unitname into typettinfo from bd_corp where pk_corp=(select pk_corp from zm_typetaxitem_h where pk_typetaxitem_h=cfpk and nvl(dr,0)=0) and nvl(dr,0)=0;
end if;
if(flag=2) then
select invclasscode into typettinfo from bd_invcl where pk_invcl=cinvpk and nvl(dr,0)=0;
end if;
if(flag=3) then
select invclassname into typettinfo from bd_invcl where pk_invcl=cinvpk and nvl(dr,0)=0;
end if;
return typettinfo ;
end;
--获取上级商品分类编码及名称
create or replace function Fun_getinvclInfo( cinvclasscode varchar2,cinvclasslev number,cflag number)
return varchar2 is
finvclinfo varchar(200) := '';
invclass_code varchar(20):='';
invclass_lev number :=0;
flag number :=0;
begin
invclass_code := trim(cinvclasscode);
invclass_code := substr(invclass_code,0,length(invclass_code)-2);
invclass_lev := cinvclasslev-1;
if(flag=0) then
select invclassname into finvclinfo from bd_invcl where invclasscode like invclass_code||'%' and invclasslev = invclass_lev;
else
finvclinfo:=invclass_code;
end if;
return finvclinfo;
end;
Fun_getRInfo(a.pk_corp, 0, '') as unitcode,Fun_getRInfo(a.pk_corp, 1, '') as unitname,Fun_getinvclInfo(a.invclasscode,a.invclasslev,0) as fatherinvclassname, Fun_getinvclInfo(a.invclasscode,a.invclasslev,1) as fatherinvclass_code
create or replace function Fun_getinvclInfo( cinvclasscode varchar2,cinvclasslev number,cflag number)
return varchar2 is
finvclinfo varchar(200) := '';
invclass_code varchar(20):='';
invclass_lev number :=0;
flag number :=0;
begin
invclass_code := trim(cinvclasscode);
invclass_code := substr(invclass_code,0,length(invclass_code)-2);
invclass_lev := cinvclasslev-1;
if(flag=0) then
select invclassname into finvclinfo from bd_invcl where invclasscode like invclass_code||'%' and invclasslev = invclass_lev;
end if
if(flag=1) then
finvclinfo:=invclass_code;
end if;
return finvclinfo;
end;
create or replace function Fun_getRInfo( cpkcorp varchar2,cflag number,cpk varchar2)
return varchar2 is
rinfo varchar(200) := '';
pkcorp varchar(20):='';
pk varchar(20):='';
flag number :=0;
begin
pkcorp := trim(cpkcorp);
flag := cflag;
pk := cpk;
--公司编码
if (flag = 0) then
if (pkcorp='0001') then
rinfo :='0001';
else
select unitcode into rinfo from bd_corp where pk_corp=pkcorp and nvl(dr,0)=0;
end if;
end if;
--公司名称
if (flag = 1) then
if (pkcorp='0001') then
rinfo :='0001';
else
select unitname into rinfo from bd_corp where pk_corp=pkcorp and nvl(dr,0)=0;
end if;
end if;
--商品分类编码
if (flag = 2) then
select invclasscode into rinfo from bd_invcl where nvl(dr,0)=0 and pk_invcl = pk;
end if;
--商品分类名称
if (flag = 3) then
select invclassname into rinfo from bd_invcl where nvl(dr,0)=0 and pk_invcl = pk;
end if;
--主计量单位编码
if (flag = 4) then
select shortname into rinfo from bd_measdoc where nvl(dr,0)=0 and pk_measdoc = pk;
end if;
--主计量单位名称
if (flag = 5) then
select measname into rinfo from bd_measdoc where nvl(dr,0)=0 and pk_measdoc = pk;
end if;
--自定义项档案列表名称
if (flag = 6) then
select doclistname into rinfo from bd_defdoclist where nvl(dr,0)=0 and pk_defdoclist = pk;
end if;
--自定义项档案列表编码
if (flag = 7) then
select doclistcode into rinfo from bd_defdoclist where nvl(dr,0)=0 and pk_defdoclist = pk;
end if;
--父级自定义项档案表名称
if (flag =
then
select docname into rinfo from bd_defdoc where nvl(dr,0)=0 and pk_defdoclist = pk;
end if;
--父级自定义项档案表编码
if (flag = 9) then
select doccode into rinfo from bd_defdoc where nvl(dr,0)=0 and pk_defdoclist = pk;
end if;
--基础数据资源表名称
if (flag = 10) then
select bdname into rinfo from bd_bdinfo where nvl(dr,0)=0 and pk_bdinfo= pk;
end if;
--基础数据资源表编码
if (flag = 11) then
select bdcode into rinfo from bd_bdinfo where nvl(dr,0)=0 and pk_bdinfo= pk;
end if;
--产品线档案名称
if (flag = 12) then
select prodlinename into rinfo from bd_prodline where nvl(dr,0)=0 and pk_prodline= pk;
end if;
--产品线档案编码
if (flag = 13) then
select prodlinecode into rinfo from bd_prodline where nvl(dr,0)=0 and pk_prodline= pk;
end if;
--税目税率名称
if (flag = 14) then
select taxname into rinfo from bd_taxitems where nvl(dr,0)=0 and pk_taxitems= pk;
end if;
--税目税率编码
if (flag = 15) then
select taxcode into rinfo from bd_taxitems where nvl(dr,0)=0 and pk_taxitems= pk;
end if;
return rinfo;
end;
return varchar2 is
fpk_invcl varchar(200) := '';
invclass_code varchar(20):='';
invclass_lev number :=0;
begin
invclass_code := trim(cinvclasscode);
invclass_code := substr(invclass_code,0,length(invclass_code)-2);
invclass_lev := cinvclasslev-1;
select pk_invcl into fpk_invcl from bd_invcl where invclasscode like invclass_code||'%' and invclasslev = invclass_lev;
return fpk_invcl;
end;
create or replace function Fun_getinvclInfo( cinvclasscode varchar2,cinvclasslev number)
return varchar2 is
fpk_invcl varchar(200) := '';
invclass_code varchar(20):='';
invclass_lev number :=0;
begin
invclass_code := trim(cinvclasscode);
invclass_code := substr(invclass_code,0,length(invclass_code)-2);
invclass_lev := cinvclasslev-1;
select pk_invcl into fpk_invcl from bd_invcl where invclasscode like invclass_code||'%' and invclasslev = invclass_lev;
select invclasscode into xx from bd_invcl where bd_invcl.pk_invcl = fpk_invcl;
return fpk_invcl;
end;
create or replace function f1(pk bd_corp.pk_corp%type) return bd_corp.unitcode%type
as
v_unitcode bd_corp.unitcode%type;
begin
select unitcode into v_unitcode from bd_corp where pk_corp=pk;
return v_unitcode;
end;
create or replace function Fun_getRInfo( cpkcorp varchar2,cflag number,cpk varchar2)
return varchar2 is
rinfo varchar(200) := '';
pkcorp varchar(20):='';
pk varchar(20):='';
flag number :=0;
begin
pkcorp := trim(cpkcorp);
flag := cflag;
pk := cpk;
--公司
if (flag = 0) then
select unitcode into rinfo from bd_corp where pk_corp=pkcorp and nvl(dr,0)=0;
end if;
if (flag = 1) then
select unitname into rinfo from bd_corp where pk_corp=pkcorp and nvl(dr,0)=0;
end if;
--商品分类
if (flag = 3) then
select invclasscode into rinfo from bd_invcl where pk_corp=pkcorp and nvl(dr,0)=0 and pk_invcl = pk;
end if;
return rinfo;
end;
select Fun_getRInfo('1114',5,'') aa ,Fun_getRInfo('1004',1,'') bb from dual;
select * from bd_invcl
create or replace function Fun_getRInfo( cpkcorp varchar2,cflag number,cpk varchar2)
return varchar2 is
rinfo varchar(200) := '';
pkcorp varchar(20):='';
pk varchar(20):='';
flag number :=0;
begin
pkcorp := trim(cpkcorp);
flag := cflag;
pk := cpk;
--公司编码
if (flag = 0) then
if (pkcorp=='0001') then
unitcode='0001'
else
select unitcode into rinfo from bd_corp where pk_corp=pkcorp and nvl(dr,0)=0;
end if;
end if;
--公司名称
if (flag = 1) then
if (pkcorp=='0001') then
unitcode='0001'
else
select unitname into rinfo from bd_corp where pk_corp=pkcorp and nvl(dr,0)=0;
end if;
end if;
--商品分类编码
if (flag = 2) then
select invclasscode into rinfo from bd_invcl where nvl(dr,0)=0 and pk_invcl = pk;
end if;
--商品分类名称
if (flag = 3) then
select invclassname into rinfo from bd_invcl where nvl(dr,0)=0 and pk_invcl = pk;
end if;
--主计量单位编码
if (flag = 4) then
select shortname into rinfo from bd_measdoc where nvl(dr,0)=0 and pk_measdoc = pk;
end if;
--主计量单位名称
if (flag = 5) then
select measname into rinfo from bd_measdoc where nvl(dr,0)=0 and pk_measdoc = pk;
end if;
--自定义项档案列表名称
if (flag = 6) then
select doclistname into rinfo from bd_defdoclist where nvl(dr,0)=0 and pk_defdoclist = pk;
end if;
--自定义项档案列表编码
if (flag = 7) then
select doclistcode into rinfo from bd_defdoclist where nvl(dr,0)=0 and pk_defdoclist = pk;
end if;
--基础数据资源表名称
if (flag = 6) then
select bdname into rinfo from bd_bdinfo where nvl(dr,0)=0 and pk_bdinfo= pk;
end if;
--基础数据资源表编码
if (flag = 7) then
select bdcode into rinfo from bd_bdinfo where nvl(dr,0)=0 and pk_bdinfo= pk;
end if;
return rinfo;
end;
--商品税率
create or replace function Fun_gettptaxiInfo(ctypetaxitempk varchar2,cinvclpk varchar2,cflag number)
return varchar2 is typettinfo varchar(200) :='';
cfpk varchar2(20):='';
cinvpk varchar2(20):='';
flag number :=0;
begin
cfpk:=ctypetaxitempk;
cinvpk:=cinvclpk;
flag:=cflag;
if(flag=0) then
select unitcode into typettinfo from bd_corp where pk_corp=(select pk_corp from zm_typetaxitem_h where pk_typetaxitem_h=cfpk and nvl(dr,0)=0) and nvl(dr,0)=0;
end if;
if(flag=1) then
select unitname into typettinfo from bd_corp where pk_corp=(select pk_corp from zm_typetaxitem_h where pk_typetaxitem_h=cfpk and nvl(dr,0)=0) and nvl(dr,0)=0;
end if;
if(flag=2) then
select invclasscode into typettinfo from bd_invcl where pk_invcl=cinvpk and nvl(dr,0)=0;
end if;
if(flag=3) then
select invclassname into typettinfo from bd_invcl where pk_invcl=cinvpk and nvl(dr,0)=0;
end if;
return typettinfo ;
end;
--获取上级商品分类编码及名称
create or replace function Fun_getinvclInfo( cinvclasscode varchar2,cinvclasslev number,cflag number)
return varchar2 is
finvclinfo varchar(200) := '';
invclass_code varchar(20):='';
invclass_lev number :=0;
flag number :=0;
begin
invclass_code := trim(cinvclasscode);
invclass_code := substr(invclass_code,0,length(invclass_code)-2);
invclass_lev := cinvclasslev-1;
if(flag=0) then
select invclassname into finvclinfo from bd_invcl where invclasscode like invclass_code||'%' and invclasslev = invclass_lev;
else
finvclinfo:=invclass_code;
end if;
return finvclinfo;
end;
Fun_getRInfo(a.pk_corp, 0, '') as unitcode,Fun_getRInfo(a.pk_corp, 1, '') as unitname,Fun_getinvclInfo(a.invclasscode,a.invclasslev,0) as fatherinvclassname, Fun_getinvclInfo(a.invclasscode,a.invclasslev,1) as fatherinvclass_code
create or replace function Fun_getinvclInfo( cinvclasscode varchar2,cinvclasslev number,cflag number)
return varchar2 is
finvclinfo varchar(200) := '';
invclass_code varchar(20):='';
invclass_lev number :=0;
flag number :=0;
begin
invclass_code := trim(cinvclasscode);
invclass_code := substr(invclass_code,0,length(invclass_code)-2);
invclass_lev := cinvclasslev-1;
if(flag=0) then
select invclassname into finvclinfo from bd_invcl where invclasscode like invclass_code||'%' and invclasslev = invclass_lev;
end if
if(flag=1) then
finvclinfo:=invclass_code;
end if;
return finvclinfo;
end;
create or replace function Fun_getRInfo( cpkcorp varchar2,cflag number,cpk varchar2)
return varchar2 is
rinfo varchar(200) := '';
pkcorp varchar(20):='';
pk varchar(20):='';
flag number :=0;
begin
pkcorp := trim(cpkcorp);
flag := cflag;
pk := cpk;
--公司编码
if (flag = 0) then
if (pkcorp='0001') then
rinfo :='0001';
else
select unitcode into rinfo from bd_corp where pk_corp=pkcorp and nvl(dr,0)=0;
end if;
end if;
--公司名称
if (flag = 1) then
if (pkcorp='0001') then
rinfo :='0001';
else
select unitname into rinfo from bd_corp where pk_corp=pkcorp and nvl(dr,0)=0;
end if;
end if;
--商品分类编码
if (flag = 2) then
select invclasscode into rinfo from bd_invcl where nvl(dr,0)=0 and pk_invcl = pk;
end if;
--商品分类名称
if (flag = 3) then
select invclassname into rinfo from bd_invcl where nvl(dr,0)=0 and pk_invcl = pk;
end if;
--主计量单位编码
if (flag = 4) then
select shortname into rinfo from bd_measdoc where nvl(dr,0)=0 and pk_measdoc = pk;
end if;
--主计量单位名称
if (flag = 5) then
select measname into rinfo from bd_measdoc where nvl(dr,0)=0 and pk_measdoc = pk;
end if;
--自定义项档案列表名称
if (flag = 6) then
select doclistname into rinfo from bd_defdoclist where nvl(dr,0)=0 and pk_defdoclist = pk;
end if;
--自定义项档案列表编码
if (flag = 7) then
select doclistcode into rinfo from bd_defdoclist where nvl(dr,0)=0 and pk_defdoclist = pk;
end if;
--父级自定义项档案表名称
if (flag =

select docname into rinfo from bd_defdoc where nvl(dr,0)=0 and pk_defdoclist = pk;
end if;
--父级自定义项档案表编码
if (flag = 9) then
select doccode into rinfo from bd_defdoc where nvl(dr,0)=0 and pk_defdoclist = pk;
end if;
--基础数据资源表名称
if (flag = 10) then
select bdname into rinfo from bd_bdinfo where nvl(dr,0)=0 and pk_bdinfo= pk;
end if;
--基础数据资源表编码
if (flag = 11) then
select bdcode into rinfo from bd_bdinfo where nvl(dr,0)=0 and pk_bdinfo= pk;
end if;
--产品线档案名称
if (flag = 12) then
select prodlinename into rinfo from bd_prodline where nvl(dr,0)=0 and pk_prodline= pk;
end if;
--产品线档案编码
if (flag = 13) then
select prodlinecode into rinfo from bd_prodline where nvl(dr,0)=0 and pk_prodline= pk;
end if;
--税目税率名称
if (flag = 14) then
select taxname into rinfo from bd_taxitems where nvl(dr,0)=0 and pk_taxitems= pk;
end if;
--税目税率编码
if (flag = 15) then
select taxcode into rinfo from bd_taxitems where nvl(dr,0)=0 and pk_taxitems= pk;
end if;
return rinfo;
end;
发表评论
-
Oracle的left join中on和where的区别
2012-10-26 15:43 990Oracle的left join中on和where的区别 数 ... -
动态sql拼接单引号与 变量赋值
2012-06-21 10:09 3870if (lower(s_table)='gl_deta ... -
ora-00031:session marked for kill处理oracle中杀不掉的锁
2012-06-19 16:36 1076转: 一些ORACLE中的进程被杀掉后,状态被置为" ... -
使用DBLINK为远程数据库的用户表创建同义词
2012-06-19 14:39 9431、创建db_link create database l ... -
以字符串数组为输入参数的存储过程
2012-06-19 14:27 2760今天项目中需要用到存 ... -
Oracle中decode的使简单例子
2012-06-04 17:06 1498decode(字段,表达式1,表达式2,表达式。。。) 当,字 ... -
oracle触发器
2012-04-20 09:11 769表: A 字段:a, b, c 当修改a字段的值时触发 c字段 ... -
oracle的全文索引
2012-04-16 14:29 806已有几个项目组开始使 ... -
单独的plsql链接数据库
2011-10-14 16:03 921转的: plsql 可不可以 ... -
Oracle经验集锦
2011-09-24 13:32 7011.删除表空间 DROP ... -
两个数据库字符集不一样,如何快速增量同步数据.
2011-09-23 15:00 1163环境: DB-A 字符集:US7ASC ... -
Oracle分区表详解 .
2011-08-06 10:42 659一、Oracle分区简介 ORACLE的分区是一种处理超大型 ... -
利用 rowid 提升update性能 .
2011-08-04 23:52 1815能不能想办法 提升一下如下update语句的性能 UPDA ... -
oracle全文索引的简单配置
2011-08-04 23:49 10121.创建数据存储定义(Datastore),使用多列数据存储在 ... -
用java调用oracle存储过程总结
2011-08-04 23:45 6541、什么是存储过程。存 ... -
Oracle SCN详解
2011-08-04 23:38 614pre. Oracle中的SCN(system change ... -
oracle 数据库里查看表空间使用状况
2011-08-04 23:34 655oracle表空间的事情状况要经常查看,一般空闲比例过低的时候 ... -
采用全文索引解决模糊查询速度慢的问题
2011-08-04 23:31 771众所周知,使用 like 进行模糊查询速度极差,包括 like ... -
oracle9i在windows上的dataguard配置
2011-08-04 23:23 713主库:win2003 server ora9i(9.2.0.1 ... -
Rman duplicate数据库复制(单系统)
2011-08-04 23:22 659一、实验环境: 1. 虚拟机:VMware Ser ...
相关推荐
Linux C函数库参考手册是一套Linux C函数使用手册,这里还提供了LinuxC函数手册chm,帮助大家查找。在Linux下,使用到的C语言函数中文手册,全都有实例,如果你是大神,完全不需要,如果你对英文的手册感到头疼,...
"二代身份证相片解码函数使用说明宣贯.pdf" 本资源是一个关于二代身份证相片解码函数的使用说明文件,该文件提供了相应的API函数和开发指南,旨在帮助开发者快速了解和使用该函数。 一、文件概述 该文件主要介绍...
LISP ssget 函数使用大全整理,涵盖该函数使用的各个方面
《VB-API函数使用手册》是一本专为VBA(Visual Basic for Applications)开发者设计的实用指南,涵盖了在VBA编程中使用API(Application Programming Interface)函数的广泛知识。API函数是Windows操作系统提供的一...
详细介绍了LIN的API函数的使用,包括代码的详细解读。
Turbo C 是一款经典的C语言编译器,...了解并熟练运用这些基本的函数使用方法,将有助于你在 Turbo C 中编写更高效、更具结构化的程序。不断实践和探索,你将逐渐掌握C语言的精髓,并为更高级的编程技能打下坚实基础。
socket_recv 函数使用心得 在学习 socket_recv 函数时,需要了解其返回值的含义和使用场景。在阻塞模式下,当网络异常时,recv 函数返回值为-1,表示连接异常,需要关闭连接。在非阻塞模式下,如果没有数据,recv ...
Oracle分析函数使用总结Oracle分析函数使用总结Oracle分析函数使用总结Oracle分析函数使用总结
在本文档中,我们主要将介绍大彩LUA脚本API函数中的绘图API函数使用方法,以及使用函数的注意事项。首先,让我们来了解一下LUA语言版本,当前文档支持的LUA版本为V5.5。接下来,我们将详细讲解如何使用绘图API函数,...
Excel 中的 COUNTA 和 COUNTIF 函数使用入门 Excel 中的 COUNTA 和 COUNTIF 函数是两种非常有用的函数,可以帮助用户快速统计单元格中的非空白单元格数量或特定值的出现次数。在本文中,我们将详细介绍 COUNTA 和 ...
"SYBASE iq与ORACLE使用分析函数计算同期值及常用计算函数使用" 本资源摘要信息主要介绍了SYBASE iq和ORACLE中使用分析函数计算同期值和常用计算函数的使用方法。文章涵盖了同期值的计算、累计及同期累计值的计算、...
Axure 9.0 高级教程:最新最全的函数使用手册 Axure 9.0 高级教程:最新最全的函数使用手册是 Axure 9.0 的一个高级教程,旨在帮助用户深入了解 Axure 9.0 的各项功能和应用。该教程涵盖了 Axure 9.0 的各种函数...
《winAPI函数使用手册》是一本专为程序员设计的实用参考书籍,主要涵盖了Windows操作系统中的所有API函数。这本书对于想要深入了解系统级编程、提高编程技能的开发者来说,是一份不可多得的资源。Windows API...
该文档是关于random函数使用详细讲解,主要在代码编写产生随机数的时候用到,详细介绍了random函数的各种用法,赶快下载看看吧~
Excel中的SumIF函数使用,Excel中的SumIF函数使用
Excel中的vlookup函数使用Excel中的vlookup函数使用
《EXCEL常用函数使用手册》是为那些已经熟悉了Excel基础操作的用户所准备的高级操作指南,其目的是通过详细的函数教学,提升读者的Excel技能,让数据处理变得更加高效和专业。本手册不仅提供了函数的基本使用方法,...
Excel 减法运算函数使用方法 Excel 减法运算函数是 Excel 中的一种重要运算函数,用于进行减法运算。本文将详细介绍 Excel 减法函数的使用方法,包括 IMSUB 函数的语法、应用实例等。 一、Excel 减法函数 IMSUB ...
ORACLE的OVER函数使用技巧ORACLE的OVER函数使用技巧ORACLE的OVER函数使用技巧
EXCEL EXCEL frequency 函数使用的一个EXCEl 可以作为参考