The site www.w3schools.com published a great SQL Tutorial, but unfortunately no PL/SQL Tutorial on w3schools.com exists.
Ok, I understand that Oracle’s PL/SQL is not directly a www language. It’s located at the backend database, mostly Oracle.
But maybe a PL/SQL Tutorial w3schools.com will be adding in the future? Could be in the category of “MORE…”
Also I thought myself creating such a learning video, but PL/SQL’s functionality scope is very wide – will be a huge work to do
On Oracle Reports and Forms calls, for security reasons, Reports user should not see the Oracle Reports URL with Userid and Password parameters.
We use "manual" Reports calls out of Forms. So we just create the URL string and open this url with web.show_document().
Because Oracle Reports uses the GET method (instead of the POST method) to pass parameters, all parameters are visible to the user within the URL (....&userid=xxx/xxxx@xxxx)
Wo when using Oracle Reports and Forms direct URL calls, I suggest to use to two steps to secure it up:
We're using Oracle Forms source control outside of Forms. Currently we're very happy with our VSS setup. So we are using Microsoft's Visual Source Safe for Oracle Forms Source Control.
Generating *.fmb files out of Oracle Designer, we do a check in of fmb files after generation.
Also there's a possibility to use ANT for SQL and fmb Forms deployment. Using VSS as Oracle Forms source control software, ANT can also check out specific fmb versions to deploy.
At the moment, some peole thing about migrating our Oracle Forms source control software from VSS to something new like SVN (Subversion). But this would be a major change on our developement approach. Currently, the developers were used to VSS with its pessimistic locking mechanism. New version control tools as Subversion are using optimistic locking instead. What's the difference?