如题
oracle可以像sqlserver那个执行动态sql语句吗?下面是我的一个sqlserver的例子Create PROCEDURE [dbo].[admin_User_Select]
@Condition varchar(1000)
AS
BEGIN
DECLARE @SqlString NVARCHAR(2000)
SET @SqlString = 'SELECT * FROM [dbo].[admin_User] WHERE ' + @Condition
EXEC sp_executesql @SqlString
End
oracle可以像sqlserver那个执行动态sql语句吗?下面是我的一个sqlserver的例子Create PROCEDURE [dbo].[admin_User_Select]
@Condition varchar(1000)
AS
BEGIN
DECLARE @SqlString NVARCHAR(2000)
SET @SqlString = 'SELECT * FROM [dbo].[admin_User] WHERE ' + @Condition
EXEC sp_executesql @SqlString
End
Create PROCEDURE dbo.admin_User_Select(Condition varchar2)
AS
SqlString VARCHAR2(2000);
BEGIN
SqlString := 'SELECT * FROM dbo.admin_User WHERE :1';
EXECUTE IMMEDIATE SqlString using Condition;
END ;
oracle动态SQL中execute immediate的使用
EXECUTE IMMEDIATE 'sqlstring'