11g , the latest database released by Oracle contains many additional features that add more functionality in coding using sql and pl/sql. So among the new features added to 11g here lists some of the features which I like to point out through this article. Following are the new features; REGEXP_COUNT Function This function takes […]
New features in Oracle 11g
Posted in Database Development by admin - Jun 30 2010
Database Normalization
Posted in Database Development by admin - Jun 07 2010
Database Normalization Database A database is a collection of information that can be stored, accessed, retrieved and updated easily with the help of tables. Tables consist of rows (corresponds to a single record) and columns (contains different types of attributes). Normalization Normalization can be simply defined as the process of efficient organization of data in […]
Database Transaction
Posted in Database Development by admin - Mar 22 2010
A database transaction comprises of the operations performed against the data in one or more databases. It is an atomic unit that contains one or more SQL statements which are executed as a whole for retrieving or updating data in the database. It may contain the operations such as SELECT, INSERT, UPDATE or DELETE singly […]