ezoic

Wednesday, August 24, 2016

How to output oracle sql results to a file without showing the results on screen

SET TERMOUT OFF;
SET WRAP OFF;
set pagesize 0;

SET COLSEP '|'
SET LINESIZE 32767

set trimspool on

spool C:\XXX\a.txt
select fox_id,fox_version_id, fin_prod_id, title_desc from zr_edm_global_title where rownum<500 ;

spool off;
exit;
the above statement can output oracle sql results to a file without showing the results on screen, and the output will be shown line by line. 


Tuesday, August 16, 2016

Given a list of single-digited integer, count how many times each digit appears

Given a list of single-digited  integer, count how many times each digit appears

Python code, now you can see the power of dictionary:

a={}
a={0:0,1:0,2:0,3:0,4:0,5:0,6:0,7:0,8:0,9:0}


b=[2,3,4,5,4,5,6]

for i in range(len(b)):
    for key in a.keys():
        if b[i]==key:
            a[key]=a[key]+1


looking for a man

 I am a mid aged woman.  I was born in 1980. I do not have any kid. no complicated  dating before . I am looking for a man here for marriage...