today:
305
yesterday:
456
Total:
1,015,631

SQL SQL

admin 2016.07.15 23:37 Views : 405

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 332
25 function get area admin 2016.06.08 337
24 DBMS_NETWORK_ACL_ADMIN admin 2016.06.07 349
23 Access Control List (ACL) admin 2016.06.07 352
22 ADD_PRIVILEGE (2nd STEP) admin 2016.06.07 362
21 DBMS_NETWORK_ACL_ADMIN admin 2016.06.07 362
20 APEX Web Services Proxy Settings admin 2016.06.07 373
19 DATE Compare admin 2018.05.22 379
» SQL admin 2016.07.15 405
17 control break admin 2016.06.25 408
16 QRCODE admin 2020.05.25 409
15 JavaScript for Member List admin 2016.08.17 442
14 Membership Management admin 2016.06.09 443
13 APEX Password Change admin 2016.08.26 468
12 CREATE TABLE admin 2018.09.25 484
11 JK admin 2019.02.05 714
10 TREE admin 2016.05.18 732
9 IMP admin 2018.10.08 739
8 SELECT last_name FROM admin 2018.12.12 759
7 INSTR admin 2016.05.19 797