deepak-sinha.blogspot.com

Quest For Knowledge

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.

http://deepak-sinha.blogspot.com/

OVERVIEW OF deepak-sinha.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

9

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR DEEPAK-SINHA.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

November

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Monday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.3 out of 5 with 12 reviews

5 star

8

4 star

1

3 star

2

2 star

0

1 star

1

Hey there! Start your review of deepak-sinha.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.6 seconds

FAVICON PREVIEW

16x16
32x32

CONTACTS AT DEEPAK-SINHA.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

9

SSL

EXTERNAL LINKS

0

SITE IP

172.217.11.33

LOAD TIME

0.628 sec

SCORE

6.2

PAGE TITLE

Quest For Knowledge | deepak-sinha.blogspot.com Reviews

<META> DESCRIPTION

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.

<META> KEYWORDS

1 quest for knowledge

2 posted by

3 deepaks techbox

4 no comments

5 email this

6 blogthis

7 share to twitter

8 share to facebook

9 share to pinterest

10 older posts

CONTENT

Page content here

KEYWORDS ON PAGE

quest for knowledge,posted by,deepaks techbox,no comments,email this,blogthis,share to twitter,share to facebook,share to pinterest,older posts,informatica,informatica best practices,oracle,data modeling,service oriented architecture,useful links,er model

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Quest For Knowledge | deepak-sinha.blogspot.com Reviews

https://deepak-sinha.blogspot.com

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.

INTERNAL PAGES

deepak-sinha.blogspot.com

1

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.

2

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

3

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

4

Quest For Knowledge: September 2008

http://deepak-sinha.blogspot.com/2008_09_01_archive.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...

5

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

UPGRADE TO PREMIUM TO VIEW 4 MORE

TOTAL PAGES IN THIS WEBSITE

9

OTHER SITES

deepak-sharma.weebly.com

Deepak Sharma - Home

Let's support each other and navigate the path to success. Be the change you want to see in the world" - M.K Gandhi.

deepak-shenoy.blogspot.com

As good as it gets

As good as it gets. Where facts and views blend to give an opinion. Saturday, October 18, 2014. Memoirs of "His and Her" - 4. Continued from the last part available. When you see yourself in an unfamiliar situation, you normally tend to think in every possible direction. This is exactly how his brain was working now. He had to figure out a way to find the mysterious " Whg 26". ". The success depended a lot on how he would pronounce the nine letters. German uses the Latin alphabet. This is where the s...

deepak-singh.com

Deepak Singh - Writer and Independent Radio Producer - Home

Redirecting to http:/ deepak-singh.com/wordpress.

deepak-sinha.blogspot.com

Quest For Knowledge

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-swain.blogspot.com

The Blogermania....

Sunday, February 7, 2010. Ever Wanted To Get All Your HOW questions answered! Get all your questions answered by experts n satisfy yourself. Links to this post. Saturday, February 6, 2010. Ever Wanted To Become A Hacker.Then Check this out. The Ethical Hacker :-. Links to this post. Wednesday, February 3, 2010. SEND FREE MMS INDIA. When using this service to Send FREE MMS India, select the proper mobile service provider from the list provided. Enter the verification text shown in the box provided. Here a...

deepak-timelesstales.blogspot.com

Timeless Tales

This blog is best viewed on Firefox, Opera or IE 7. Internet Explorer 6 might not properly display the pages. Enter your email address:. Top 10 Free Online Radio Stations for You to Play . Top 10 Free Online Radio Stations for You to Play . Top 10 Websites For You To Play Music According To. Top 10 Websites To Watch Movies Online For Free Wi. 14 Websites for Free eBooks Downloading. How To Search For Images With Images. Top 10 Websites to Download Free Audio Books. Follow me on Twitter. On 1FM, there are...

deepak-tourisminnepal.blogspot.com

Tourism in Nepal

Wednesday, December 8, 2010. Nepal is a hot favorite among trekkers and mountaineers.The trekking in Nepal has captured the imagination of mountaineers and explores for more than 100 years. Trekking requires physical efforts too. There needs many more equipment for trekking. Some of them are as follows. Backpack, Sleeping Bag, Sleeping Pad, Duffel Bag(Bag for storage purpose), Luggage Locks (locking for duffel bags). Hat for warmth, Sun hat, Sun glass. Gloves/Mittens, Fleece Gloves. Became the abode of H...

deepak-verma.co.uk

Deepak Verma

8220;Faith Shorts provides the opportunity to build understanding and break down some of the prejudices which can surround religion. There were outstanding, honest and challenging film entries from all over the world last year. It has been inspiring to see the competition provide young people with a voice to express what their faith means to them across borders, on a global level.”.

deepak-verma.com

Deepak Verma | Actor

Deepak trained as an Actor at the prestigious Central School of Speech and Drama in London and since then has made various television appearances on UK mainstream networks. His body of acting work includes ‘Eastenders’, one of the UK’s top long running drama series.