http://www.packtpub.com/article/external-tables-oracle-10g-11g-database-part1 In this two-part article by Hector R. Madrid, we will learn about the External Tables in Oracle 10g/11g Database. When working in data warehouse environments, the Extraction—Transformation—Loading (ETL) cycle frequently requires the user to load information from external sources in plain file format, or perform data transfers among Oracle database in a proprietary format. This requires the user to create control files to perform the load. As the format of the source data regularly doesn't fit the one required by the Data Warehouse, a common practice is to create stage tables that load data into the database and create several queries that perform the transformation from this point on, to take the data to its final destination. A better approach, would be to perform this transformation 'on the fly' at load time. That is what External Tables are for. They are basically external files, managed either...
Using Triggers and Compound Triggers in Oracle 11g By Contributing Author on June 16, 2011 in Database Development , Oracle Database In database terminology, triggers are the objects which demonstrate the logic of schedule and automation. Triggers are automatically invoked at a defined event and timing without any explicit calls. The logic embedded within the trigger and invocation must be well directed and synchronized to maintain database purity. Oracle 11g made remarkable enhancements in Database Triggers. These enhancements and additions have transformed triggers into a logical, stable, and comprehensive database platform. In the past versions, developers used to face issues under certain conditions as listed below. Multiple triggers for single timing Mutating table confrontation Control the trigger execution by enabling and disabling it Introduction of compound triggers which triggers different logic at different timings, guaranteed execution sequence of t...
Access Control exit - terminate a shell (see "man sh" or "man csh") logout - sign off; end session (C shell and bash shell only;) passwd - change login password rlogin - log in remotely to another UNIX system ssh - secure shell slogin - secure version of rlogin yppasswd - change login password in yellow pages Communications mail - send and receive mail mesg - permit or deny terminal messages and talk requests pine - send and receive mail talk - talk to another logged-in user write - write to another logged-in user Programming Tools as - assembler, specific to each machine architecture awk - pattern scanning and processing language bc - online calculator cc - C compiler csh - C shell command interpreter dbx - source-level debugging program f77 - Fortran compiler gdb - GNU Project debugger gprof - display profile of called routines kill - kill a process ld - the UNIX loader lex - generate lexical analysis programs lint - check C source code make - maintain l...
Comments