Pass bind parameters to SQL query; Execute query Activity; UiPath RPA

 ? are used to pass bind parameters from arguments.

Informative screenshot on UiPath forum.

Execute Query Activity-

select * from employees where department = ?

Arguments passed in UiPath

https://forum.uipath.com/t/passing-string-as-parameter-in-sql-query/188680/13

 

Decode function in Oracle; Example

 https://www.techonthenet.com/oracle/functions/decode.php

Search text in Oracle DB; Returns all types of Oracle function where this text appears;

Select * from ALL_SOURCE  where TEXT LIKE '%Approval%'   

or 

Select * from dba_source where upper(text) like '%ENTER THE TEXT YOU WANT TO SEARCH HERE%'