today:
284
yesterday:
316
Total:
1,018,212

SQL CREATE TABLE

admin 2018.09.25 19:56 Views : 491

CREATE TABLE DEDUCTION_RESULT 
("DEDUCT_ID" NUMBER, "MISSIONARY_ID" VARCHAR2(20),"RECEIPT_NO" NUMBER,"SUPPORTER_ID" NUMBER, "AMOUNT" NUMBER,"CONTRIBUTION_DATE" DATE ,"DEDUCTION" NUMBER )

 CREATE SEQUENCE   "DEDUCTION_RESULT_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999 INCREMENT BY 1 START WITH 100 CACHE 20 NOORDER  NOCYCLE

CREATE OR REPLACE TRIGGER  "INSERT_DEDUCTION_RESULT" 
BEFORE INSERT ON DEDUCTION_RESULT
FOR EACH ROW
DECLARE
  DEDUCT_ID_sv number;
  SELECT DEDUCTION_RESULT_SEQ.nextval
    INTO DEDUCT_ID_sv
    FROM dual;
  :new.DEDUCT_ID := DEDUCT_ID_sv;
  
End;
No. Subject Author Date Views
41 Monthly SUM admin 2023.05.22 67
40 LOOP TABLE UPDATE admin 2023.05.19 79
39 STARTUP admin 2022.09.01 109
38 ACTION admin 2019.01.11 6479
37 SELECT last_name FROM admin 2018.12.12 768
» CREATE TABLE admin 2018.09.25 491
35 VERY IMPORTANT admin 2018.06.26 250
34 MISSIONARY_SUB admin 2018.06.25 223
33 TABLE PRINT admin 2018.06.18 210
32 GP PRINT admin 2018.05.31 934
31 How to convert DATE to NUMBER admin 2018.05.27 217
30 DATE Compare admin 2018.05.22 384
29 Oracle SQL Developer: Online Migration 3.1 admin 2018.04.25 149
28 How to Update Oracle XE admin 2018.04.25 161
27 SQL admin 2016.07.15 416
26 SUBSTR admin 2016.05.26 289
25 FOR LOOP admin 2016.05.20 293
24 ROWNUM admin 2016.05.19 255
23 NVL admin 2016.05.19 175
22 INSTR admin 2016.05.19 814