today:
204
yesterday:
1,189
Total:
1,007,584

SQL Global & Custom Serach

admin 2016.04.28 13:28 Views : 129

-- Global Serach --



select * from (
select CUSTOMER_ID, Initcap( CUST_LAST_NAME ||','|| CUST_FIRST_NAME   ) Name, 
CUST_CITY, CREDIT_LIMIT, CUST_EMAIL, NLS_TERRITORY,
case ACCOUNT_MGR_ID
  when   1 then 'John'
    when   2 then  'Bill'
    when 3 then 'Smith'
   when  4 then 'Joe'
        when 5 then 'Ron' else
         'N/A'
         end as MGR_id
   from DEMO_CUSTOMERS
where instr(upper(CUST_LAST_NAME), upper  ( nvl (:P1_CUST_LAST_NAME,CUST_LAST_NAME))) > 0

AND instr(upper(CUST_FIRST_NAME), upper  ( nvl (:P1_CUST_FIRST_NAME,CUST_FIRST_NAME))) > 0

order by 1)
where (
 instr(upper("NAME"),upper(nvl(:P1_SEARCH,"NAME"))) > 0  or
 instr(upper("CUST_CITY"),upper(nvl(:P1_SEARCH,"CUST_CITY"))) > 0  or
 instr(upper("CUST_EMAIL"),upper(nvl(:P1_SEARCH,"CUST_EMAIL"))) > 0  or
 instr(upper("NLS_TERRITORY"),upper(nvl(:P1_SEARCH,"NLS_TERRITORY"))) > 0  or
 instr(upper("MGR_ID"),upper(nvl(:P1_SEARCH,"MGR_ID"))) > 0
)

No. Subject Author Date Views
» Global & Custom Serach file admin 2016.04.28 129
85 Null Display Value admin 2024.01.10 130
84 HEAD TITLE (제목)을 조건에 따라 바꾸기 admin 2016.05.03 133
83 LAST DAY SQL admin 2024.01.19 135
82 APEX Connect 2016 - David Peake - New Features in Oracle Application Express 5.1 admin 2017.11.25 136
81 Oracle APEX 5.1.4 Installation admin 2018.04.17 138
80 How to Update Oracle XE admin 2018.04.25 139
79 Delimiter admin 2016.04.29 141
78 COUNT admin 2016.04.28 147
77 BOOLEAN SAMPLE admin 2016.05.11 147
76 Outer Join with Oracle SQL admin 2016.04.29 148
75 Field Showing admin 2016.04.01 149
74 Column Data 일괄 추가 admin 2023.11.24 149
73 CREATE (INSERT) PROCESS admin 2016.04.28 151
72 NVL admin 2016.05.19 152
71 Forgot Oracle username and password, how to retrieve? admin 2022.03.18 152
70 PHONE NUMBER admin 2016.04.28 153
69 MAX admin 2016.04.28 155
68 wwv_flow_files admin 2016.05.01 155
67 SQL Developer Password change / EXPORT & IMPORT admin 2022.03.18 157