Execute queries stored as text in table

[Brett]

Good afternoon,

There is a function on Oracle called sql_execute that I've used to be able to execute queries that are stored in tables. We've used this as a means of limiting the queries folks can run in the database. Is this possible in vertica? For example if I store SELECT * FROM DUAL; in a table column I'd like to be able to dynamically query the table to run that statement.

[JimKnicely]

You can do it in vsql like this:

Code: Select all

dbadmin=> select * from sql;
          c
---------------------
 select * from dual;
(1 row)

dbadmin=> \! /opt/vertica/bin/vsql -At -c "select * from sql" | vsql
 dummy
-------
 X
(1 row)

[Brett]

knicely,

Thanks for your reply. Do you think I can do what you gave as an example in a tool such as Tableau?