xml
Get flash to fully experience Pearltrees
example
Oracle Application Server Wiki
In computing , the Oracle Application Server 10g (the "g" stands for grid ) [ citation needed ] (short Oracle AS ), consists of an integrated, standards-based software platform . It forms part of Oracle Corporation 's Fusion Middleware technology stack . The heart of Oracle Application Server consists of Oracle HTTP Server (based on Apache HTTP Server ) and OC4J (OracleAS Containers for Java EE ) which deploys Java EE -based applications .Previous Database Release Software Oracle Database 10.2 and 11.1 are no longer available for download. The software is available as a media or FTP request for those customers who own a valid Oracle Database product license for any edition. To request access to these releases, follow the instructions in Oracle Support Document 1071023.1 (Requesting Physical Shipment or Download URL for Software Media) from My Oracle Support. NOTE: for Oracle Database 10.2, you should request 10.2.0.1 even if you want to install a later patch set. Once you install 10.2.0.1 you can then apply any 10.2 patch set.
Database Downloads
Installing Oracle Database 10g Release 2 on Linux x86
Tech Article: Real-Time Topic Modeling of Microblogs This article explores the challenge of real-time extraction of topics from a continuous stream of incoming microblogs or tweets. Learn how to apply LDA to tweets for topic modeling. posted Thu, 28 Mar 2013 15:48:54 +0000 Tech Article: Why, Where, and How JavaFX Makes Sense CaptainCasa moved from Swing to JavaFX for front-end infrastructure, explaining that implementing an employee desktop front end with native technology is a valid approach and that JavaFX is a good fit. posted Thu, 14 Mar 2013 19:22:09 +0000 Tech Article: How to Multiply the Capacity of Oracle Storage Systems Hybrid columnar compression can effectively multiply your storage capacity by 10-15 times, increasing performance and reducing your hardware costs. It's available on Oracle's Pillar Axiom storage systems. Tom Luckenbach walks you through the steps to set it up. posted Mon, 04 Mar 2013 16:44:26 +0000
DBMS_LOB: PSOUG tutorial on this oracle package
>> Actually, I have already done my own tests and it doesn't. >> I can only retrieve 4000 as you already mentioned as >> opposed to the 64000 we're used to, but I think that this >> is a good trade off considering that we were doing almost >> 5000 queries at a time. Perhaps you could consider tuning the temp tablespace extent size to retain the ability to fetch 64000 bytes. Consider this test case (9.2.0.5, 8k block size): CREATE TABLE don (x clob); DECLARE l_clob clob; BEGIN FOR i IN 1..10 LOOP INSERT INTO don (x) VALUES (empty_clob()) RETURNING x INTO l_clob;The DBMS_LOB package provides subprograms to operate on BLOBs , CLOBs , NCLOBs , BFILEs , and temporary LOBs . You can use DBMS_LOB to access and manipulation specific parts of a LOB or complete LOBs . DBMS_LOB can read and modify BLOBs , CLOBs , and NCLOBs ; it provides read-only operations for BFILEs . The bulk of the LOB operations are provided by this package. Requirements This package must be created under SYS (connect internal).
Oracle: DBMS_LOB - package to manage all aspects of BLOBS, etc.
Overloading Procedures in PL/SQL
A FAQ that I get, well, frequently, is about overloading procedures. I think most people get how to overload but not when or why. Today I am going to explain a classic example of where overloading makes your life easier. More importantly, it makes the life of the code maintainer behind you easier.
Oracle9 i XML Developer's Kits Guide - XDK Release 2 (9.2) Part Number A96621-01 Using XML Parser for PL/SQL Examples in the Sample Directory Frequently Asked Questions About the XML Parser for PL/SQL Frequently Asked Questions About Using the DOM API XML Parser for PL/SQL is provided with Oracle9 i and is also available for download from the OTN site: http://otn.oracle.com/tech/xml .
XML Parser for PL/SQL
I've written some in the past about Oracle and XML. A couple of days ago, some coworkers had a requirement and I created a simple example to show them one possible solution. I thought I would share that here. The requirement was to have a stored procedure accept an XML document and insert it into a table. The XML document was fairly complex and contained a lot of information not required by the application.
Oracle and XML In Action - A Real World Example
Oracle9i Parse XML Documents
Related articles. The use of XML for data transfer has increased dramatically over the last few years. Since most applications still rely on structured relational data it is necessary to explode the non-structured XML data into relations tables. Oracle9i Release 2 includes the XDK for PL/SQL packages loaded into the SYS schema by default, but these have been superseded by a set of integrated DBMS_% packages within the XDB schema. I shall present a simple example of using the new XDB packages to load employee records into the EMP table.Data types for Oracle 8 to Oracle 11g Notes and Examples VARCHAR2: Storing character data as Varchar2 will save space: Store 'SMITH' not 'SMITH ' Oracle9i and above allow Varchar2 columns to be defined as a number of bytes VARCHAR2(50 BYTE) or a number of characters VARCHAR2(50 CHAR) , the latter is useful if the database is ever converted to run a double-byte character set (such as Japanese), you won't have to edit the column sizes.
Oracle Data Types
There are a number of ways to kill rogue sessions both within Oracle and externally. Identify the Session to be Killed Killing sessions can be very destructive if you kill the wrong session, so be very careful when identifying the session to be killed. If you kill a session belonging to a background process you will cause an instance crash.
Killing Oracle Sessions
To understand bind variables, consider an application that generates thousands of SELECT statements against a table; for example: SELECT fname, lname, pcode FROM cust WHERE id = 674; SELECT fname, lname, pcode FROM cust WHERE id = 234; SELECT fname, lname, pcode FROM cust WHERE id = 332; Each time the query is submitted, Oracle first checks in the shared pool to see whether this statement has been submitted before. If it has, the execution plan that this statement previously used is retrieved, and the SQL is executed. If the statement cannot be found in the shared pool, Oracle has to go through the process of parsing the statement, working out the various execution paths and coming up with an optimal access plan before it can be executed. This process is know as a « hard parse » and for OLTP applications can actually take longer to carry out that the DML instruction itself.
Oracle Bind variables - The key to application performance
Oracle XML Reference Oracle possesses a variety of powerful XML features. A tremendous amount of documentation exists regarding Oracle's XML features.