由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - Help:java call oralce stored procedure
相关主题
用Servlet显示数据库里的数据,分页的? (很实际的问题)请教:如何用java调用外部函数,更新数据库?
请教一个sql server的问题问个数据库问题
a question for JDBCOralce for Linux 的问题
Re: [转载] JDBC用完了oracle的large pool (memorRe: recursive sql?
Re: Job with Oracle PL? (转载)where is ora 00922 from?
stored procedure running 很慢的问题How to delete Oracle SID?
关于not closed cursor的请教Re: How to populate data from text or MS ACCESS file to Oracle Database?
改写(migrate) stored proc 问题how to get the result in the middle of resultset?
相关话题的讨论汇总
话题: stored话题: procedure话题: oralce话题: oracle话题: emp
进入Database版参与讨论
1 (共1页)
a**k
发帖数: 29
1
I am a new beginner in JDBC and Oracle stored procedures. Would you please
help me
to solve the following practical question?
There is a table:
emp: fname, lname, dept, gender
if I want to select:
select * from emp where gender='m';
1. How could I write oracle stored procedure/function?
2. How could I writeJDBC to call stored procedure/function? I want to use
CallableStatement and ResultSet.
c**g
发帖数: 274
2
google.

【在 a**k 的大作中提到】
: I am a new beginner in JDBC and Oracle stored procedures. Would you please
: help me
: to solve the following practical question?
: There is a table:
: emp: fname, lname, dept, gender
: if I want to select:
: select * from emp where gender='m';
: 1. How could I write oracle stored procedure/function?
: 2. How could I writeJDBC to call stored procedure/function? I want to use
: CallableStatement and ResultSet.

a**k
发帖数: 29
3
google does not work well. i already checked a lot.

【在 c**g 的大作中提到】
: google.
1 (共1页)
进入Database版参与讨论
相关主题
how to get the result in the middle of resultset?Re: Job with Oracle PL? (转载)
Re: why?ORACLE的c编程中,循环语句中如果出现数据库语句,循环就会死掉stored procedure running 很慢的问题
[转载] Re: Redhat 7.3能把缺省语言从中文改成英文么?关于not closed cursor的请教
在linux7.3下安装oracle8.1.7问题改写(migrate) stored proc 问题
用Servlet显示数据库里的数据,分页的? (很实际的问题)请教:如何用java调用外部函数,更新数据库?
请教一个sql server的问题问个数据库问题
a question for JDBCOralce for Linux 的问题
Re: [转载] JDBC用完了oracle的large pool (memorRe: recursive sql?
相关话题的讨论汇总
话题: stored话题: procedure话题: oralce话题: oracle话题: emp