pydoing2.blogspot.com
Programming Tutorial Blog: Perl Learning Resources
http://pydoing2.blogspot.com/2013/08/Perl-Learning-Resources.html
Free tutorials of C, C , C#, Java, JavaScript, Objective-C, Perl, PHP, Python, Ruby and Swift programming . Each original tutorial was written in Chinese and it is rewriting in English by the author. How to Become a Self-Taught Programmer. One Lesson of Python V1.00. Beginner's Programming Guide with Python V3.40. Beginner's Programming Tour Guide with Python V2.00. How to Become a Self-Taught Programmer. One Lesson of Python. Beginner's Programming Tour with Python. The Perl Programming Language. Perl B...
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...
deepak-sinha.blogspot.com
Quest For Knowledge: Oracle: Import/Export, COPY, Datapump utilities expdp/impdp
http://deepak-sinha.blogspot.com/2008/09/oracle-importexport-copy-datapump.html
Tuesday, September 30, 2008. Oracle: Import/Export, COPY, Datapump utilities expdp/impdp. Refreshing data in DEV/QA from PROD. Following methods can be used:. 1 Export/Import utilities can be used. But it requires. First export tables into dump file. Drop tables in DEV/QA environment. Import export dumps (see below in detail the exp/imp). 2 Oracle Data Pump in Oracle Database 10g (impdp/expdp). Exp scott/tiger file=emp.dmp log=emp.log tables=emp rows=yes indexes=no. Where export.txt is like. Before runni...