SQL SERVER 例子:SELECT CategoryID, CategoryName, Description
FROM Categories
WHERE (CategoryID = @categoryid)
但这个例子在ORACLE中好象不行!能不能帮我写一个在ORACLE加入参数据的例子?
谢谢!!!
robinhui@sohu.com
...全文
1485打赏收藏
如何在SQL 语句中加入参数?
SQL SERVER 例子:SELECT CategoryID, CategoryName, Description FROM Categories WHERE (CategoryID = @categoryid) 但这个例子在ORACLE中好象不行!能不能帮我写一个在ORACLE加入参数据的例子? 谢谢!!! robinhui@sohu.com
create procedure pro(p_categoryid in varchar2)
as
v_CategoryID Categories.CategoryID%type;
v_CategoryName Categories.CategoryName%type;
v_Description Categories.Description%type;
begin
SELECT CategoryID, CategoryName, Description into v_CategoryID, v_CategoryName, v_Description
FROM Categories
WHERE CategoryID =p_categoryid;
end;
/