oracleinout.blogspot.com
Sandeep Panchal Blog: First Step : Oracle DBA
http://oracleinout.blogspot.com/2010/04/first-step-oracle-dba.html
Creating a knowledge base from my learnings and to share it with Oracle community. New Delhi, New Delhi, India. Oracle Certified Master 11g Over 12 years of IT experience in Oracle database and Oracle Applications Administrator. To know more about Oracle Certification visit http:/ education.oracle.com/. View my complete profile. Link with Sandeep Panchal. India News - Times of India. How To Decide Partition Range - Sql To Find Equal Range In Table. Oracle UCM : Oracle Universal Content Management. You ca...
en.wikipedia.org
Database normalization - Wikipedia, the free encyclopedia
https://en.wikipedia.org/wiki/Database_normalization
From Wikipedia, the free encyclopedia. Is the process of organizing the columns. Relations) of a relational database. To reduce data redundancy. And improve data integrity. Normalization involves arranging attributes in tables based on dependencies. Edgar F. Codd. The inventor of the relational model. RM), introduced the concept of normalization and what we now know as the First normal form. Codd went on to define the Second normal form. 2NF) and Third normal form. 3NF) in 1971,. List of Normal Forms.
deepak-sinha.blogspot.com
Quest For Knowledge: Oracle Useful SQL Scripts
http://deepak-sinha.blogspot.com/2008/10/oracle-useful-sql-scripts.html
Friday, October 10, 2008. Oracle Useful SQL Scripts. Below are the scripts that will convert multiple records into single record. e.g. concatenate all the employee name based on their deptno separated by ',' as shown below:. 30 ALLEN,BLAKE,JAMES,MARTIN,TURNER,WARD 20 ADAMS,FORD,JONES,SCOTT,SMITH 10 CLARK,KING,MILLER. With data as (select ename,deptno, row number () over (partition by deptno order by ename) rn, count (*) over (partition by deptno order by ename) cnt. Create table emp1 as with data as (sel...
deepak-sinha.blogspot.com
Quest For Knowledge: October 2008
http://deepak-sinha.blogspot.com/2008_10_01_archive.html
Friday, October 10, 2008. Oracle Useful SQL Scripts. Below are the scripts that will convert multiple records into single record. e.g. concatenate all the employee name based on their deptno separated by ',' as shown below:. 30 ALLEN,BLAKE,JAMES,MARTIN,TURNER,WARD 20 ADAMS,FORD,JONES,SCOTT,SMITH 10 CLARK,KING,MILLER. With data as (select ename,deptno, row number () over (partition by deptno order by ename) rn, count (*) over (partition by deptno order by ename) cnt. Create table emp1 as with data as (sel...
deepak-sinha.blogspot.com
Quest For Knowledge: January 2009
http://deepak-sinha.blogspot.com/2009_01_01_archive.html
Wednesday, January 21, 2009. Subtraction Between Dates in Oracle. See the example below:. Select to char(source created dt,'dd.mm.yyyy:hh24:mi:ss') as creation date,. To char(source changed dt,'dd.mm.yyyy:hh24:mi:ss') as modification date,. Trunc(86400*(source changed dt-source created dt) -60*(trunc( 86400*(source changed dt-source created dt) /60) as secs,. Trunc( 86400*(source changed dt-source created dt) /60)-60*(trunc( (86400*(source changed dt-source created dt) /60)/60) as mins,. Quote of the Day.
deepak-sinha.blogspot.com
Quest For Knowledge: Service Oriented Architecture
http://deepak-sinha.blogspot.com/2008/09/service-oriented-architecture.html
Tuesday, September 16, 2008. SOA (service-oriented architecture) has gained its popularity due to web services. Before dive in depth of SOA it is essential to have knowledge about its evolution. To do this we have to look back at the challenges developers have faced over the past decades and observe the solutions that have been proposed to solve their problems. To avoid above problem higher level of abstraction was needed. So concept of classes and object-oriented. It was good solution for reuse and main...
deepak-sinha.blogspot.com
Quest For Knowledge: Subtraction Between Dates in Oracle
http://deepak-sinha.blogspot.com/2009/01/subtraction-between-dates-in-oracle.html
Wednesday, January 21, 2009. Subtraction Between Dates in Oracle. See the example below:. Select to char(source created dt,'dd.mm.yyyy:hh24:mi:ss') as creation date,. To char(source changed dt,'dd.mm.yyyy:hh24:mi:ss') as modification date,. Trunc(86400*(source changed dt-source created dt) -60*(trunc( 86400*(source changed dt-source created dt) /60) as secs,. Trunc( 86400*(source changed dt-source created dt) /60)-60*(trunc( (86400*(source changed dt-source created dt) /60)/60) as mins,. Quote of the Day.
deepak-sinha.blogspot.com
Quest For Knowledge: Informatica Best Practices
http://deepak-sinha.blogspot.com/2008/09/informatica-best-practices.html
Friday, September 26, 2008. 1 Mapping Development Standards. Naming conventions for mappings will be in the form of - m. Subject Area: Datawarehouse, ODS or Data mart names etc. Dimension/Fact/Table: Name of the dimension or fact or related table. Use underscore wherever required to name dimension and facts. Ex: m VISION ACTION RESULT CODES. Use same convention as mapping name with prefix MPLT ;. Source Qualifier Transformation SQ. Update Strategy Transformation UPD. For any reusable Transformation.
deepak-sinha.blogspot.com
Quest For Knowledge: Oracle SQL Tuning TIPS
http://deepak-sinha.blogspot.com/2008/10/in-this-blog-i-am-going-to-write-about.html
Saturday, October 4, 2008. Oracle SQL Tuning TIPS. In this blog I am going to write about some basic rules and tips that can enhance query performance by reducing parsing,execution, or both. These rules are simple but may yield lots of benefits. 1 Use SQL standards within an application. Below are the simple rules that are easy to implement and allow more sharing within Oracle’s memory. A Using a single case for all SQL verbs. B Beginning all SQL verbs on a new line. SELECT account name, trans date, amou...