This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi all. I have a data connection in which I have SQL code doing a basic select* from a PERSON table in my database. I would like it to dynamically fill in the table name in my formula tool. Currently, I'm entering the table name manually and it's a pain. Any ideas? I'm on 2018.2 if that matters. Thanks!
And for the good of the order, I wanted to list what worked for me. For my Oracle SQL, this was the correct syntax to create that column to the right of all the others. I needed the table name (or alias like here) then a dot and the asterisk. Thanks again! @Thableaus@john_miller9
SELECT PERSON.* ,'PERSON' as Table_Name from ORACLE_DATABASE.V_PERSON PERSON