Tag: Database

Are your Web applications in a need for a face-lift to match the Web 2.0 generation of user interfaces? Don't have time to learn Javascript and Ajax technologies and work out browser compatibility issues? Come and see the simpler approach to building Web and Mobile based user interfaces that are dynamic, powerful, and sexy using…

Throughout my 16 years working with Oracle, I have accumulated a list of tips and techniques that assist with the development of Oracle based custom applications. These tips and tricks can be used to improve application performance, to streamline code, and to create higher quality applications. The speaker will describe each topic in detail as…

Oracle Forms is a strong and viable product with years of future left. However, Oracle has “bet the farm” on the success of Fusion; Oracle’s rewrite of its Application stack using Java EE and Service-Oriented Architecture. A key tool in this development effort has been the JDeveloper tool and the Oracle Application Development Framework (ADF).…

This presentation will show the top ten tips when tuning your architecture for grid computing. Oracle has come a long when from when they first introduced clustering. The tools continue to improve and the installation continues to get better and easier. The main focus is to show many of the Grid Control screen shots so…

Oracle Application Express (APEX) provides a convenient way of building the basic page structures necessary to guide a user through a multi-step process. This capability can be leveraged to build wizards into complex APEX applications, thereby reducing user errors and training costs. The end result is an application that is both reliable and cost effective…

This paper describes using the Oracle® Generic Connectivity gateway (OGC) to transparently integrate tables in a Microsoft SQL Server database with an Oracle database. While there are many other ways to federate data from multiple data sources, OGC offers several advantages. • OGC federation uses simple configuration files eliminating the need to write and maintain…

This paper describes using the Oracle® Generic Connectivity gateway (OGC) to transparently integrate tables in a Microsoft SQL Server database with an Oracle database. While there are many other ways to federate data from multiple data sources, OGC offers several advantages. • OGC federation uses simple configuration files eliminating the need to write and maintain…

New in Oracle Database 11gR2, the "recursive common table expression" (CTE) gives us yet another tool to manage hierarchical data. A recursive CTE is composed of one or more "anchor members" followed by one or more "recursive members." For example, to find all the ancestors of George Walker Bush, we create anchor members that list…

Prior to 10G, Raw Device or 3rd party cluster filesystem were the only options for Oracle RAC or OPS. Starting with 10G, even with popularity of ASM using Raw luns over FC storage network, NFS is often a much cheaper and viable option. In the case study - the same storage system was assigned as…

Oracle releases fixes for security vulnerabilities on a quarterly basis in the form of a Critical Patch Update (CPU). The CPU is a collection of security patches for the Oracle Database, Oracle Application Server, Oracle Collaboration Suite, and Oracle business applications, including both the Oracle E-Business Suite and PeopleSoft applications. The first CPU was released…