pl sql
RSS pl sqlGuide to Migrating From Oracle to SQL Server 2008
White Paper The entire migration process using SQL Server Migration Assistant (SSMA) 2008 for Oracle is explained in depth, with a special focus on converting database objects and PL/SQL code. This... [16 Sep 2009]
How to Write SQL Injection Proof PL/SQL
White Paper This whitepaper dymystifies the topic and explains a straightforward approach to writing database PL/SQL programs that provably guarantees their immunity to SQL injection. Only when a... [02 Sep 2009]
Data Transformations With Oracle Data Pump
White Paper The REMAP_DATA parameter allows a user-supplied PL/SQL function to modify user data as Data Pump transfers the data. Database Administrators (DBAs) sometimes need to modify the data being exported out of... [31 Jul 2009]
Axione Saves More Than 15 Hours Per Month by Automating Business Statistics Publishing Processes
White Paper Axione replaced Axione's PL/SQL publishing procedure with Oracle Business Intelligence Publisher - improving technician and sales agent productivity and provided Axione with a standalone demonstrator... [30 Jul 2009]
Sebrae Parana Reduces Disc Storage Requirements by 70% With a Corporate Portal
White Paper Sebrae worked with Oracle Partner, DB Master, to create a corporate portal operating on Linux RedHat AS40, with virtual work environments, real-time collaboration, and workgroup forums and agendas as well as implemented a portal in eight... [29 Apr 2009]
Oracle Database 11g - Implementing Web Services for Complex Event Processing (CEP) With Rules Manager
White Paper Oracle Database 10g supports creating web services for Rules Manager operations using PL/SQL packages, procedures and functions. Web services can be created for Rules Manager runtime operations to... [05 Feb 2009]
PHP Scalability and High Availability: Database Resident Connection Pooling and Fast Application Notification
White Paper It has support for basic and advanced Oracle Database features, allowing easy and efficient use of SQL and PL/SQL. PHP is a popular dynamic programming language for web applications. PHP... [18 Jul 2008]
Portal Enhances Manageability, Performance, and Security With New Server Solution
White Paper To demonstrate the advantages of the latest software to users and to improve the site itself, the owners of CentrumXP.pl deployed Windows Server 2008 along with Microsoft SQL Server 2008 and Microsoft... [03 Jul 2008]
Exchange Data Using Arrays in SQL PL: New Capabilities for Exchanging Data Between Applications and Stored Procedures
White Paper IBM DB2 9.5 for Linux, UNIX and Windows introduces support for array data types in SQL Procedural Language (SQL PL). In addition to being useful as a data structure to develop... [09 Apr 2008]
More on Oracle Database 11g
White Paper PL/SQL is Oracle's procedural extension to SQL, and it is a true 3GL programming language. The ability to store PL/SQL in the database came with version... [29 Mar 2008]
Building Queries Visually
White Paper Oracle SQL Developer provides the SQL worksheet, a code-editor window where one can enter and run statements that include SQL*Plus commands, SQL, and... [29 Mar 2008]
On Ignoring, Locking, and Parsing
White Paper There's a programming construct, WHEN OTHERS, in PL/SQL that the author wishes weren't there. This clause, when used in an exception block, catches any unhandled exceptions. There are times when this is... [29 Mar 2008]
ODP.NET Developer's Guide: Oracle Database 10g Development With Visual Studio 2005 and the Oracle Data Provider for .NET
White Paper It deals with the concepts of ODP.NET and its requirements, working with SQL, PL/SQL, and XML DB using ODP.NET, looking at application development with ODP.NET: Web Applications, Web... [28 Mar 2008]
Using PL/SQL Associative Arrays
White Paper And second, applications that use Oracle databases must use PL/SQL for access to the database structures. Knowing that one needs to use PL/SQL in the database as the... [20 Mar 2008]
Working With PL/SQL
White Paper Among its other features, Oracle SQL Developer provides database developers and DBAs with a comprehensive environment for creating, editing, compiling, running, and debugging PL/SQL... [20 Mar 2008]
