Browsing posts in the ‘Oracle’ category

thumb

Tags in Oracle Nested Tables

Joe Lennon
Oracle, Tutorials
, , , , ,

Tags are a useful means of associating keyword metadata with a data structure such as an image, a video, audio or a piece of text. There are many ways of storing tags in a database - for example one could store a string of tags...

Read More »
Install Apache and mod_owa

Install Apache and mod_owa

13
Joe Lennon
Oracle, Tutorials
, , , , , ,

In order to develop PL/SQL applications on Oracle XE, we are going to need to install a web server (Apache) and a PL/SQL gateway for Apache called mod_owa. On a regular Oracle Application Server you would probably be using Oracle...

Read More »
Oracle Database Basics

Oracle Database Basics

Joe Lennon
Oracle, Tutorials
, , , ,

In this tutorial, I will be looking at the basics of Oracle databases, namely, the creation of database tables and inserting of data rows. I will be showing you two ways of interacting with the database: 1.) via Oracle's Application Express Web-Based Interface; and 2.)Via...

Read More »
Installing Oracle Database 10g Express Edition

Install Oracle XE

5
Joe Lennon
Oracle, Tutorials
, , , ,

Oracle Database 10g Express Edition (I will refer to this as Oracle XE from here on) is a basic version of the Oracle Database 10g that is freely available for development, deployment and distribution. It is an excellent entry-level database for learning Oracle and PL/SQL...

Read More »