User Defined Input


User Defined Input

Oracle has a command that allows a user to input a variable and then that variable gets used in the SQL.

Select data
From table1
TO_NUMBER(TO_CHAR(db1.table1.effective_dt,'YYYY')) in @variable('Enter Years (separated by a comma)') AND....

When the query is run, a pop-up window appears asking the user which years he/she wants to look at.

Does Teradata have a similar function that reads input information and then uses that within the SQL?

Ultimately, I want to create an Excel model that is reading from a Teradata database and I want the users to input info into message boxes and have that input used in the SQL.