The online whiteboard of Kristofer Palmvik

10 links collected from oracle.com between 2011 and 2016

Sorting: Oldest links first
Domain: oracle.com

2011

2011-01-26 download.oracle.com
Triggers and Stored Procedures
This chapter describes the differences between Microsoft SQL Server or Sybase Adaptive Server and Oracle
2011-02-08 download.oracle.com
Managing Editions
Edition-based redefinition enables you to upgrade an application’s database objects while the application is in use, thus minimizing or eliminating down time. This is accomplished by changing (redefining) database objects in a private environment known as an edition. Only when all changes have been made and tested do you make the new version of the application available to users.
2011-02-16 oracle.com
Oracle Database Firewall
Oracle Database Firewall is the first line of defense for databases, providing real-time monitoring of database activity on the network. Highly accurate SQL grammar-based technology blocks unauthorized transactions, helping prevent internal and external attacks from reaching the database. Oracle Database Firewall is easy to deploy, requiring no changes to existing applications or databases.
2011-02-18 oracle.com
Doing SQL from PL/SQL: Best and Worst Practices
This paper examines and categorizes the use cases for doing SQL from PL/SQL, takes the Oracle Database 11g viewpoint, and explains the optimal approach for the task at hand.
2011-02-18 oracle.com
How to write SQL injection proof PL/SQL
Only when a PL/SQL subprogram executes SQL that it creates at run time is there a risk of SQL injection; and you’ll see that it’s easier than you might think to freeze the SQL at PL/SQL compile time. Then you’ll understand that you need the rules which prevent the risk only for the rare scenarios that do require run-time-created SQL. It turns out that these rules are simple to state and easy to follow.
2011-02-28 download.oracle.com
Data Type Comparison Rules
This section describes how Oracle Database compares values of each data type.
2011-03-07 oracle.com
Advanced MDATA - tips and tricks
The document presents a variety of techniques, along with code samples.

» More links from 2011

↑ Back to top

2013

2013-09-18 docs.oracle.com
Deploying an Oracle Database Application
However, for a complex application, the order for creating the objects is rarely obvious. Usually, you must consult the database designer or a diagram of the design.

» More links from 2013

↑ Back to top

2015

2015-10-29 blogs.oracle.com
Why use PL/SQL?
The thick database paradigm: the only kind of SQL statement that is allowed from outside-of-the-database entities is the primitive anonymous PL/SQL block. Every business function needs just a single round trip to and from the database. Thereafter, the PL/SQL-SQL-PLSQL round trips that implement the business functions take place within the same operating system process

» More links from 2015

↑ Back to top

2016

2016-04-02 blogs.oracle.com
Schema deployments and rollbacks in the regime of the thick database paradigm (Oracle Database PL/SQL and EBR)
The critical, and exciting, difference for the task of patching the user-defined artifacts inside an Oracle Database is that this can be done with zero downtime by taking advantage of edition-based redefinition

» More links from 2016

↑ Back to top