today:
1,122
yesterday:
1,189
Total:
1,008,502

SQL ACTION

admin 2019.01.11 11:13 Views : 6458

declare
  M_action integer;
begin
  select count(*)
    into M_action
    from MNEWS
   where MYEAR = :P18_YEAR and MMONTH = :P18_MONTH;

  if( M_action >= 1 )
  then
    :P18_SELECT := 2;
  else 
    :P18_SELECT := 1;
  end if;
end;
I want to
List
No. Subject Author Date Views
46 ACL 보기 admin 2016.06.07 310
45 Oracle 11g Access Control List for External Network Services admin 2016.06.07 302
44 Access Control List (ACL) admin 2016.06.07 343
43 CAPTCHA PLUG-IN admin 2016.05.27 300
42 SUBSTR admin 2016.05.26 272
41 FOR LOOP admin 2016.05.20 269
40 ROWNUM admin 2016.05.19 240
39 NVL admin 2016.05.19 152
38 INSTR admin 2016.05.19 791
37 TREE admin 2016.05.18 722
36 3D Pie Chart admin 2016.05.17 222
35 CREATE VIEW admin 2016.05.13 220
34 test admin 2016.05.11 123
33 BOOLEAN SAMPLE admin 2016.05.11 147
32 Display Value, Return Value admin 2016.05.10 118
31 Fundamentals of PL/SQL admin 2016.05.10 2041
30 Interactive Report admin 2016.05.07 119
29 Group by, Order by (두개의 Table을 활용한 Sub Total / 최고값 ) admin 2016.05.06 235
28 EMPLOYEE_LEVEL_ID admin 2016.05.03 89
27 HEAD TITLE (제목)을 조건에 따라 바꾸기 admin 2016.05.03 135
Write Tag