Scripts

» SQL Scripts
• functions_x_user.sql v1.0
It will return which functions a user can access.
[BLOG POST]
• scheduled_programs.sql v1.0
It will return the scheduled concurrent programs and request sets.
[BLOG POST]
• forms_used_by_user.sql v1.0
It will return the forms used by a user in the last number of days.
[BLOG POST]

» Linux Bash Scripts
• FormPersonalizationTransfer.sh v1.0
It will automate the transfer of one or more form personalization from an environment to another.
[HOW TO USE IT]
• OracleViaPHP.sh v1.2 [Linux Ubuntu Server 8.04.1]
It will install and configure Apache2, PHP5, OracleClient v10.2 and the OCI8 v1.3.3.
[HOW TO USE IT]
• TNSconnect.sh v1.0 [Linux Ubuntu Server 8.04.1]
It will create/update the file tnsnames.ora and it will create a test page that will try to connect the Oracle DB.
[HOW TO USE IT]

» Mac OS X Bash Scripts
• MacOracleViaPHP.sh v1.1 [Mac OS X Leopard 10.5.4]
It will install and configure Apache2, PHP5, the OCI8 v1.3.3, the OracleClient v10.2 and SqlPlus.
[HOW TO USE IT]
• TNSconnectMac.sh v1.0 [Mac OS X Leopard 10.5.4]
It will create/update the file tnsnames.ora.
[HOW TO USE IT]
• MacSqlPlus.sh v1.1 [Mac OS X Leopard 10.5.4]
It will install SqlPlus on your Mac
[HOW TO USE IT]