Re: Dynamic or Static

From: <foredstest_at_gmail.com>
Date: Wed, 1 Aug 2012 01:10:44 -0700 (PDT)
Message-ID: <3ac0c953-8b80-4cb3-8762-5fcb5eec066b_at_googlegroups.com>

Do You mean that variant followed will be the best?

CREATE OR REPLACE FUNCTION bind_sql( pparameter table_name.col_name%TYPE ) RETURN SYS_REFCURSOR IS

    RESULT SYS_REFCURSOR;
    vSql VARCHAR2( 1000 );
BEGIN
    vSql := 'SELECT * FROM table_name WHERE :p IS NULL OR col_name LIKE :p';     OPEN RESULT FOR vSql USING pparameter, pparameter;     RETURN ( RESULT );
END bind_sql; Received on Wed Aug 01 2012 - 03:10:44 CDT