Query DB Columns

select * from all_tab_columns where column_name like '%PRODUCT_CODE%' and OWNER in ('ODS2','DW2') and DATA_LENGTH <> 100 and table_name
not like '%BKP' and table_name not like '%FACT_%' and table_name not like '%TRX_%' and table_name not like '%$%' and table_name not like 'BKP%'
and not REGEXP_LIKE(table_name, '[[:digit:]]')
order by owner, table_name;
select * from ods2.enum_mast where enum_type = 'ProductBatchRequirementType';
select * from dw2.enum_dim where enum_type = 'ProductBatchRequirementType';

select from ODS2.sales_trx;
ALTER TABLE DW2.INVOICE_FACT MODIFY PRODUCT_CODE VARCHAR(100);

ALTER TABLE

select * from all_tab_columns where column_name like '%CODE%' and OWNER in ('ODS2','DW2') and DATA_LENGTH = 20 and table_name
not like '%BKP' and table_name not like '%FACT_%' and table_name not like '%TRX_%' and table_name not like '%$%' and table_name not like 'BKP%' and table_name = 'INVOICE_TRX'
and not REGEXP_LIKE(table_name, '[[:digit:]]')
order by owner, table_name;

select * from all_tab_columns where (column_name = 'CUSTOMER_DESC' or column_name = 'CUSTOMER_NAME') and OWNER in ('ODS2','DW2') and table_name
not like '%BKP' and table_name not like '%FACT_%' and table_name not like '%TRX_%' and table_name not like '%$%' and table_name not like 'BKP%'
and not REGEXP_LIKE(table_name, '[[:digit:]]')
order by owner, table_name;

rom ods2.product_mast where src_created_by_code <> 'NA';


Comments

Post a Comment

Popular posts from this blog

External Tables in Oracle 10g/11g Database: Part 1

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...
Read more
Image
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...
Read more

Unix Commands - Advanced

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...
Read more