CREATE PROCEDURE dbo.getTable
@tableName varchar(50)
@fieldName varchar(20) NULL
@value varchar(20) @fieldName
AS
IF @fieldName NULL
BEGIN
EXEC ('SELECT * FROM '+ @tableName)
END
ELSE
BEGIN
EXEC ('SELECT * FROM ' + @tableName + ' WHERE ' + @fieldName + ' ' + @value + ' ')
END
GO

Its very simple

write a procedure which will build a runtime SQL for you.

try this

create or replace procedure P_For_Test(PIN_ACCOUNT_NO number)

IS

strSQl varchar2(1000);

begin

strsql : ' ';

strsql : strsql ||'select * from <table name> where acc_no ' ||

write a procedure which will build a runtime SQL for you.

try this

create or replace procedure P_For_Test(PIN_ACCOUNT_NO number)

IS

strSQl varchar2(1000);

begin

strsql : ' ';

strsql : strsql ||'select * from <table name> where acc_no ' || PIN_ACCOUNT_NO

execute immediate strsql ;

end;

using this method u can build a runtime query and execute it . The most interesting fact is that u can run a DML statement in PL/SQL using this method.

bye