Sunday, August 12, 2007

key flexfield


key flexfield is a field made up of segments, where each segment has both a value and a meaning. You can think of a key flexfield as an “intelligent” field that your business can use to store information represented as “codes.”

Most organizations use ”codes” made up of meaningful segments to identify general ledger accounts, part numbers, and other business entities. Each segment of the code can represent a characteristic of the entity. For example, consider an account number for a bank. A complete bank number may consists of various segments like the country code, area code, city code, branch code, account type, account number etc

What is SQL*Loader and what is it used for?

SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database. Its syntax is similar to that of the DB2 Load utility, but comes with more options. SQL*Loader supports various load formats, selective loading, and multi-table loads

Friday, August 10, 2007

Introduction to TOAD

TOAD is powerful development tool to build an advanced SQL/PLSQL . Using TOAD, developers can build and test PL/SQL packages, procedures, triggers and functions. You can create and edit database tables, views, indexes, constraints and users. Simply, the GUI object browser provide quick access to database object.