today:
270
yesterday:
1,189
Total:
1,007,650

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
» ACTION admin 2019.01.11 6458
40 GP PRINT admin 2018.05.31 920
39 INSTR admin 2016.05.19 789
38 SELECT last_name FROM admin 2018.12.12 744
37 TREE admin 2016.05.18 722
36 CREATE TABLE admin 2018.09.25 471
35 SQL admin 2016.07.15 397
34 DATE Compare admin 2018.05.22 368
33 SUBSTR admin 2016.05.26 272
32 FOR LOOP admin 2016.05.20 269
31 ROWNUM admin 2016.05.19 240
30 Group by, Order by (두개의 Table을 활용한 Sub Total / 최고값 ) admin 2016.05.06 234
29 VERY IMPORTANT admin 2018.06.26 227
28 Report by Order / Product / Order and Product / By Order & Non Order admin 2016.04.29 220
27 CREATE VIEW admin 2016.05.13 219
26 Name Show admin 2016.04.28 203
25 MISSIONARY_SUB admin 2018.06.25 201
24 How to convert DATE to NUMBER admin 2018.05.27 198
23 TABLE PRINT admin 2018.06.18 186
22 CREATING A TABLE / SEQUENCE / TRIGGER admin 2016.04.28 172
Write Tag