Kosmos world

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 '%$...

Source : https://www.linkedin.com/pulse/step-by-step-guide-creating-sql-hierarchical-queries-bibhas-mitra 1. Introduction Hierarchical query is a type of SQL query that is commonly leveraged to produce meaningful results from hierarchical data. Hierarchical data is defined as a set of data items that are related to each other by hierarchical relationships. Hierarchical relationships exist where one item of data is the parent of another item. The real-life examples of the hierarchical data that are commonly stored in databases include the following: Employee hierarchy (employee-manager relationship) Organizational hierarchy Graph of links between web pages Connected social networking graph A set of tasks in a project File system Unless your database is a hierarchical database like IBM Information Management System (IMS), you will need to write hierarchical SQL to retrieve relational data in hierarchical format that establishes parent-child relationships between entities ...

So now that I have installed oracle 12C ..its time to look into its new features. I struggled a bit to build the oracle 12c server on my laptop. After a few rounds of failed installations I could successfully install oracle 12C on the windows7 64bit Laptop. Initially I downloaded two different zip files so when I was trying to install them it was showing some installation files were missing and later on I re-downloaded the correct one files and started the installation. I guess next time it failed as there is something with the privileges on my work laptop which did not let the installation go through. Finally oracle 12c is up and running on my laptop...yay..! so time to fidget with it..! So here I start with some new features . refrerence : http://www.orafaq.com/node/2822 01. Pluggable Databases Through Database Consolidation: Oracle is doing every thing to jump into the cloud bandwagon. With 12C, Oracle is trying to address the problem of Multitenancy through this...