today:
190
yesterday:
311
Total:
1,018,429

SQL Global & Custom Serach

admin 2016.04.28 13:28 Views : 144

-- 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
41 Field Showing admin 2016.04.01 160
40 UPDATE PROCESS admin 2016.04.28 188
39 PHONE NUMBER admin 2016.04.28 168
38 Name Show admin 2016.04.28 217
37 MAX admin 2016.04.28 174
36 LIST OF VALUE (DYNAMIC) admin 2016.04.28 139
35 INSERT PROCESS admin 2016.04.28 176
» Global & Custom Serach file admin 2016.04.28 144
33 DELETE PROCESS admin 2016.04.28 180
32 CREATE (INSERT) PROCESS admin 2016.04.28 167
31 CREATING A TABLE / SEQUENCE / TRIGGER admin 2016.04.28 186
30 COUNT admin 2016.04.28 170
29 SQL SELECT DISTINCT Statement admin 2016.04.29 173
28 Report by Order / Product / Order and Product / By Order & Non Order admin 2016.04.29 239
27 Outer Join with Oracle SQL admin 2016.04.29 155
26 HEAD TITLE (제목)을 조건에 따라 바꾸기 admin 2016.05.03 150
25 EMPLOYEE_LEVEL_ID admin 2016.05.03 106
24 Group by, Order by (두개의 Table을 활용한 Sub Total / 최고값 ) admin 2016.05.06 247
23 Display Value, Return Value admin 2016.05.10 139
22 CREATE VIEW admin 2016.05.13 241