How to query table count from oracle DB and display the result in appian screen?
I have used the below "Query Database" smart service to fetch the number of table count from DB. But I receive the below error:
"You should enter only a single query in a row."
My query - SELECT COUNT(1) AS NO_OF_TABLE_CNT FROM USER_TABLES;
Please help me to get the table count. Is there any other option available apart from using this Query Database smart service?
Discussion posts and replies are publicly visible