To all database engineers, when creating stored procedures or functions, you frequently implement repetitive processes (loops), don't you? Loop processing is essential when batch processing large ...

Create a Dynamic Action on a Page Load of Page 0 in your application. Provide an SQL query to fetch data from your existing database table, next supply a proper column mapping. Configure fetching ...

Have you experienced breaking an app because you forgot to add or update new database objects? That’s one hell of a disruption to your users. Doing some Oracle schema compare could have avoided the ...

This project integrates HPLSQL as PL/SQL interpreter, stores PL/SQL code in Vertica database, and run them on Vertica. Vertica PL/SQL can run in two deploy modes: This is the recommended mode, as it ...