文件名称:1
- 所属分类：
- 系统编程
- 资源属性：
- [Windows] [Visual.Net] [源码]
- 上传时间：
- 2015-12-24
- 文件大小：
- 89kb
- 下载次数：
- 0次
- 提 供 者：
- asds****
- 相关连接：
- 无
- 下载说明：
- 别用迅雷下载，失败请重下，重下不扣分！
介绍说明－－下载内容均来自于网络，请自行研究使用
使用函数完成以下功能，根据部门号，计算部门号员工工资总和-
SELECT SUM(SALARY)INTO V_sum FROM EMPLOYEES WHERE DEPARTMENT_ID=dept_no
RETURN v_sum
EXCEPTION
WHEN NO_DATA_FOUND THEN
DBMS_OUTPUT.PUT_LINE( 你需要的数据不存在! )
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE(SQLCODE|| - ||SQLERRM)
SELECT SUM(SALARY)INTO V_sum FROM EMPLOYEES WHERE DEPARTMENT_ID=dept_no
RETURN v_sum
EXCEPTION
WHEN NO_DATA_FOUND THEN
DBMS_OUTPUT.PUT_LINE( 你需要的数据不存在! )
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE(SQLCODE|| - ||SQLERRM)
(系统自动生成,下载前可以参看下载内容)
下载文件列表
ConsoleApplication2\ConsoleApplication2\bin\Debug\ConsoleApplication2.exe
...................\...................\...\.....\ConsoleApplication2.pdb
...................\...................\...\.....\ConsoleApplication2.vshost.exe
...................\...................\...\.....\ConsoleApplication2.vshost.exe.manifest
...................\...................\ConsoleApplication2.csproj
...................\...................\obj\x86\Debug\ConsoleApplication2.csproj.FileListAbsolute.txt
...................\...................\...\...\.....\ConsoleApplication2.exe
...................\...................\...\...\.....\ConsoleApplication2.pdb
...................\...................\...\...\.....\DesignTimeResolveAssemblyReferencesInput.cache
...................\...................\Program.cs
...................\...................\...perties\AssemblyInfo.cs
...................\ConsoleApplication2.sln
...................\ConsoleApplication2.suo
..................1\ConsoleApplication1\bin\Debug\ConsoleApplication1.exe
...................\...................\...\.....\ConsoleApplication1.pdb
...................\...................\...\.....\ConsoleApplication1.vshost.exe
...................\...................\...\.....\ConsoleApplication1.vshost.exe.manifest
...................\...................\ConsoleApplication1.csproj
...................\...................\obj\x86\Debug\ConsoleApplication1.csproj.FileListAbsolute.txt
...................\...................\...\...\.....\ConsoleApplication1.exe
...................\...................\...\...\.....\ConsoleApplication1.pdb
...................\...................\...\...\.....\DesignTimeResolveAssemblyReferencesInput.cache
...................\...................\Program.cs
...................\...................\...perties\AssemblyInfo.cs
...................\ConsoleApplication1.sln
...................\ConsoleApplication1.suo
..................3\ConsoleApplication3\bin\Debug\ConsoleApplication3.exe
...................\...................\...\.....\ConsoleApplication3.pdb
...................\...................\...\.....\ConsoleApplication3.vshost.exe
...................\...................\...\.....\ConsoleApplication3.vshost.exe.manifest
...................\...................\ConsoleApplication3.csproj
...................\...................\obj\x86\Debug\ConsoleApplication3.csproj.FileListAbsolute.txt
...................\...................\...\...\.....\ConsoleApplication3.exe
...................\...................\...\...\.....\ConsoleApplication3.pdb
...................\...................\...\...\.....\DesignTimeResolveAssemblyReferencesInput.cache
...................\...................\Program.cs
...................\...................\...perties\AssemblyInfo.cs
...................\ConsoleApplication3.sln
...................\ConsoleApplication3.suo
..................6\ConsoleApplication6\bin\Debug\ConsoleApplication6.exe
...................\...................\...\.....\ConsoleApplication6.pdb
...................\...................\...\.....\ConsoleApplication6.vshost.exe
...................\...................\...\.....\ConsoleApplication6.vshost.exe.manifest
...................\...................\ConsoleApplication6.csproj
...................\...................\obj\x86\Debug\ConsoleApplication6.csproj.FileListAbsolute.txt
...................\...................\...\...\.....\ConsoleApplication6.exe
...................\...................\...\...\.....\ConsoleApplication6.pdb
...................\...................\...\...\.....\DesignTimeResolveAssemblyReferencesInput.cache
...................\...................\Program.cs
...................\...................\...perties\AssemblyInfo.cs
...................\ConsoleApplication6.sln
...................\ConsoleApplication6.suo
..................2\ConsoleApplication2\obj\x86\Debug\TempPE
..................1\ConsoleApplication1\obj\x86\Debug\TempPE
..................3\ConsoleApplication3\obj\x86\Debug\TempPE
..................6\ConsoleApplication6\obj\x86\Debug\TempPE
..................2\ConsoleApplication2\obj\