Oracle variable val1 varchar2(100)execute :val1 := '123' print :val1 select * from tab1 where col1 = :val1; MySQL PREPARE stmt1 FROM 'SELECT * from tab1 where col1=?';SET @a = 2;EXECUTE stmt1 USING @a;DEALLOCATE PREPARE stmt1; PostgreSQL h…