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.
Author:
Cnu Bandi
Subscribe to:
Posts (Atom)