today:
138
yesterday:
311
Total:
1,018,377

SQL SQL

admin 2016.07.15 23:37 Views : 416

select 
null, '#' || g.SGROUP_ID "SGROUP_ID",
t.IMEMBER_SK, t.SMEMBER_ID, t.SFAMILY_ID, t.ISORT_ID, t.SFAMILYRELATION_ID,
 t.SNATIVE_NM || '' ||    case 
when substr (g.SGROUP_ID,4,1) = '1'and substr (g.SGROUP_ID,5,1) is null and t.GROUP_SORT_KEY = 'Y'
 then ' <htmL><b><font color="Red"> *** </font></b></html>' 

when t.GROUP_LEADER_KEY = 'Y' then ' <htmL><b><font color="Red"> ** </font></b></html>'  

when t.GROUP_SORT_KEY = 'Y'  then '<htmL><b><font color="Red"> * </font></b></html>' else '  '  end SNATIVE_NM,  
   
case  when substr (t.STELPERSONAL, 1,3) = '111'  then '<htmL><blink><font color="Red">Not Provided</font></blink></html>'   else to_char (t.STELPERSONAL)  end  as STELPERSONAL,

case when t.IBIRTH_DT = 0 or t.IBIRTH_DT = 11111111 then '<htmL><blink><font color="Red">Not Provided</font></blink></html>' else to_char (substr(t.IBIRTH_DT,5,2)) || '/' || to_char (substr(t.IBIRTH_DT,7,2)) || '/' || to_char (substr(t.IBIRTH_DT,1,4)) END as "IBIRTH_DT", 
   
CASE  when t.STITLE = '' or substr(t.STITLE,1,1) = '%' then '-'  ELSE to_char (t.STITLE ) END  AS Title, t.ILEADMEMBER_SK ,  tt.SNATIVE_NM  as Leader
from TBLCHURCHMEMBER t,   TBLGROUP g, TBLCHURCHMEMBER tt
where   
  t.GROUP_CELL_FLAG = 'Y'  
and substr(t.SMEMBER_ID,6,2) in ('HD','SP','P1','P2')
and t.ICELLGROUP_SK =  g.IGROUP_SK 
and substr( g.SGROUP_ID,1,1) != '9'
and t.ILEADMEMBER_SK = tt.IMEMBER_SK
order by  "SGROUP_ID", t.GROUP_SORT_KEY, "SFAMILY_ID", "SFAMILYRELATION_ID")
No. Subject Author Date Views
26 How to set a proxy in UTL_HTTP admin 2016.06.07 341
25 function get area admin 2016.06.08 345
24 Access Control List (ACL) admin 2016.06.07 355
23 DBMS_NETWORK_ACL_ADMIN admin 2016.06.07 357
22 DBMS_NETWORK_ACL_ADMIN admin 2016.06.07 372
21 ADD_PRIVILEGE (2nd STEP) admin 2016.06.07 373
20 APEX Web Services Proxy Settings admin 2016.06.07 380
19 DATE Compare admin 2018.05.22 384
18 control break admin 2016.06.25 411
17 QRCODE admin 2020.05.25 412
» SQL admin 2016.07.15 416
15 JavaScript for Member List admin 2016.08.17 453
14 Membership Management admin 2016.06.09 454
13 APEX Password Change admin 2016.08.26 469
12 CREATE TABLE admin 2018.09.25 491
11 JK admin 2019.02.05 717
10 TREE admin 2016.05.18 741
9 IMP admin 2018.10.08 745
8 SELECT last_name FROM admin 2018.12.12 768
7 INSTR admin 2016.05.19 814