各位大侠，我用PB连上Oracle数据库后怎么写SQL语句啊
string name,password
select username,userpwd into :name,:password from user_admin
where username=:sle_username.text and userpwd=:sle_pwd.text;
这样没有查询结果
应该怎么写啊

string name,password
select username,userpwd into :name,:password from user_admin
where username=:sle_username.text and userpwd=:sle_pwd.text;
是把　username,userpwd 　插入到　name,password
用messagebox('name',name)
messagebox(password ,password )show一下，
看有沒有數據。有的話說明有查出數據。

没有数据的，我也是这样输出一下的但是没有

string name,password
string ls_user,ls_pwd
ls_user=sle_username.text
ls_pwd=sle_pwd.text
select username,userpwd into :name,:password from user_admin
where username=:ls_user and userpwd=:ls_pwd;

看`要没`数据````

同意上述的,select username,userpwd into :name,:password from user_admin
where username=:ls_user and userpwd=:ls_pwd;