有关ORACLE存储过程的问题,紧急求救!在线等待 RC1 IN OUT RISEOFFICEALLEMPLOYEEPkg.RCT1%type 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 (p_RC1 IN OUT RISEOFFICEALLEMPLOYEEPkg.RCT1)--把游标名不要与包中的声明游标名相同 as...str varchar2(500);beginstr:='SELECT D.Country "Country", D.State "State", D.City "City", D.Address "Address", D.Office "Office", D.Name "Department_Name", D.TabIndex "DTagIndex", E.Email "Email", E.Name "Name", E.Sex "Sex", E.BirthDay "BirthDay", E.JobTitles "JobTitles", E.OfficePhone "OfficePhone", E.OfficeAddress "OfficeAddress", E.OfficeZipCode "OfficeZipCode", E.TabIndex "ETagIndex" FROM risemanager.EmployeeDefine E, Risemanager.DepartmentDefine D WHERE E.Department_ID <> -1 AND E.Department_ID = D.ID ORDER BY "DTagIndex" , "ETagIndex"' ;open p_RC1 for str;end;/ oracle exp怎样过滤不用的表 紧急求救横列数据动态生成 这个触发器要怎么做?? 关于存储过程和触发器 导入数据库的时候出现下面提示,谁能帮我解答? 做Oracle DBA要会些什么问题 分组 with cube/rollup 如何根据已有的记录更改主键后插入数据库中(sql语句) 定时导出数据库的批处理文件如何写? 使用sqluldr2,运行程序没有执行,也无报错。 oracle9i For Solaris 8安装的时候数据库实例不能创建 问一个简单的触发器问题.
--把游标名不要与包中的声明游标名相同
as
...
str varchar2(500);
begin
str:='SELECT D.Country "Country", D.State "State", D.City "City", D.Address "Address", D.Office "Office", D.Name "Department_Name", D.TabIndex "DTagIndex", E.Email "Email", E.Name "Name", E.Sex "Sex", E.BirthDay "BirthDay", E.JobTitles "JobTitles", E.OfficePhone "OfficePhone", E.OfficeAddress "OfficeAddress", E.OfficeZipCode "OfficeZipCode", E.TabIndex "ETagIndex" FROM risemanager.EmployeeDefine E, Risemanager.DepartmentDefine D
WHERE E.Department_ID <> -1
AND E.Department_ID = D.ID
ORDER BY "DTagIndex" , "ETagIndex"' ;
open p_RC1 for str;
end;
/