Variables in SELECT
From: Jeff Houston <fn649_at_cleveland.Freenet.Edu>
Date: 24 Feb 1995 15:24:08 GMT
Message-ID: <3iktmo$8i1_at_usenet.INS.CWRU.Edu>
Date: 24 Feb 1995 15:24:08 GMT
Message-ID: <3iktmo$8i1_at_usenet.INS.CWRU.Edu>
Is it possible to use a parameter input to a procedure to provide a table name for a PL/QSL select statement? The following statement does not substitute for the table name, but prompts the user for input during compilation:
SELECT COUNT(*) FROM '&1' WHERE deptno IS NOT NULL
Assigning the parameter to a variable, and using the variable in the above statement did not work either. Any thoughts? Received on Fri Feb 24 1995 - 16:24:08 CET