740
社区成员
发帖
与我相关
我的任务
分享
declare my_cursor dynaminc cursor for SQLSA;
int Emp_id_var
String Emp_state_var = 'MA'
String Sqlstatement
Sqlstatement = 'select emp_id from employee where emp_state= ?'
prepare sqlsa from :Sqlstatement;
open dynamic my_cursor using :Emp_state_var;
fetch my_cursor into :Emp_id_var;
close my_cursor;
string Emp_state_var = 'MA'
int Emp_id_var
declare my_cursor cursor for
select emp_id from employee where emp_state = :Emp_state_var;
open my_cursor;
fetch my_cursor into :Emp_id_var;
close my_cursor;
wf_1(MA)
int Emp_id_var
declare my_cursor cursor for
select emp_id from employee where emp_state = :Emp_state_var;
open my_cursor;
fetch my_cursor into :Emp_id_var;
close my_cursor;