Events in Oracle 11g Database
Generally, jobs run immediately upon being enabled, or when we call the run_job procedure of the dbms_scheduler package. Many jobs are time-based; they are...
Building Personal Community in Liferay Portal 5.2
Besides public web sites, it would be nice if we could provide a personal community, that is, My Community, for each registered user. In...
Setting up the most Popular Journal Articles in your Personalized Community in Liferay Portal
Personal community is a dynamic feature of Liferay portal. By default, the personal community is a portal-wide setting that will affect all of the...
Visual MySQL Database Design in MySQL Workbench
MySQL Workbench is a visual database design tool recently released by MySQL AB. The tool is specifically for designing MySQL database.
What you build in...
Creating a View with MySQL Query Browser
Please refer to an earlier article by the author to learn how to build queries visually.
Creating a View from an Existing Query
To create a...
The ASP.NET Repeater Control
The Repeater control in ASP.NET is a data-bound container control that can be used to automate the display of a collection of repeated list...
PostgreSQL’s Transaction Model
On Databases
Databases come in many forms. The simplest definition of a database is any system of storing, organizing, and retrieving data. With this definition,...
Creating a Simple Report using BIRT
Setting up a Simple Project
The first thing we want to do when setting up our simple report project is to define what the project...
Comparing Cursor and Set Approaches in Processing Relational Data
To give you an idea about cursor, the following DECLARE statement creates a cursor (named zero_bal_crs), which gives you access to the rows of...
ADO.NET Entity Framework
Creating an Entity Data Model
You can create the ADO.NET Entity Data Model in one of the two ways:
Use the ADO.NET Entity Data Model...