today:
264
yesterday:
456
Total:
1,015,590

SQL ACTION

admin 2019.01.11 11:13 Views : 6468

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
106 Delimiter admin 2016.04.29 145
105 Report by Order / Product / Order and Product / By Order & Non Order admin 2016.04.29 231
104 Outer Join with Oracle SQL admin 2016.04.29 155
103 EXPORT & IMPORT admin 2016.05.01 180
102 wwv_flow_files admin 2016.05.01 159
101 APEX ADMIN PASSWORD 바꾸기 admin 2016.05.02 124
100 HEAD TITLE (제목)을 조건에 따라 바꾸기 admin 2016.05.03 142
99 EMPLOYEE_LEVEL_ID admin 2016.05.03 99
98 Group by, Order by (두개의 Table을 활용한 Sub Total / 최고값 ) admin 2016.05.06 242
97 Interactive Report admin 2016.05.07 127
96 Fundamentals of PL/SQL admin 2016.05.10 2050
95 Display Value, Return Value admin 2016.05.10 132
94 BOOLEAN SAMPLE admin 2016.05.11 154
93 test admin 2016.05.11 135
92 CREATE VIEW admin 2016.05.13 234
91 3D Pie Chart admin 2016.05.17 231
90 TREE admin 2016.05.18 731
89 INSTR admin 2016.05.19 797
88 NVL admin 2016.05.19 160
87 ROWNUM admin 2016.05.19 246
Write Tag