The document below contains patterns of bad SQL and PL/SQL code that Gojko Adzic has repeatedly found in various applications and databases. Some of the bad practices include:
Use of WHEN OTHERS in exception handling.
Embedding complex SQL inside PL/SQL code.
Poor PL/SQL error handling.
Hardcoding the size of PL/SQL variables.
Not using bind variables.
Storing ROWIDs for later reference.
Storing [...]
Hear Oracle Vice President, Edward Zou, discuss why automated enterprise role management has become one of the key IT initiatives this year and how such a solution can ease administrative burden, improve security and compliance for your organization.
Link to the original site
Hear Wayne Boerger, Senior Product Manager for Content Management, talk about Oracle Universal Online Archive and how it provides a scalable, flexible and cost-effective platform for archiving all types of enterprise information. Learn why data center managers, email administrators, and compliance officers are all looking at Oracle’s new solution for meeting their information archiving challenges.
Link [...]
Oracle E-Business Suite offers best-in-class applications to streamline businesses processes. But a heterogeneous enterprise with Oracle E-Business Suite and other systems can easily become an environment where identity and access information is fragmented and difficult to manage.This podcast explores ways in which Identity Management solutions can be deployed alongside enterprise applications to ensure compliance, improve [...]
Andy MacMillan, Vice President of Product Management at Oracle and Al Hoof, Director of Content Management at the City of Minneapolis, and President of the Minnesota Stellent User Group and the Stellent SIG at IOUG, talk about the Oracle content management conference within a conference at COLLABORATE ‘08. They discuss the goals for the [...]
Miranda Nash,Senior Director of Development,Oracle Fusion Middleware,describes Oracle’s Data Integration strategy and why data integration is key to a successful Service-Oriented Architecture.
Link to the original site
Simon Thorpe,Senior Sales Consultant, discusses how Oracle Information Rights Management uses encryption to extend information management beyond the repository. Learn how to prevent unauthorized access and maintain control over your documents,even after they leave your organization.
Link to the original site
Ted Farrell, Oracle’s VP of Development Tools, describes using Oracle’s strategy and technologies for building Rich Internet Applications (RIAs) that offer the best of all worlds across Java, AJAX and Flash.
Link to the original site
Michelle Huff, Product Management Director for Oracle Content Management, explains how organizations can use a platform approach for multisite management. With Oracle Universal Content Management as the foundation, learn how you can easily manage, integrate and reuse content and services for multiple web sites.
Link to the original site
Hear Thomas Varghese, VP, Product Management, discuss why online identity thefts, phishing, and banking frauds are more prevalent today. Learn what you can do to protect your customers and your enterprise assets from such orchestrated crimes.
Link to the original site