today:
125
yesterday:
311
Total:
1,018,364

SQL CREATING A TABLE / SEQUENCE / TRIGGER

admin 2016.04.28 13:34 Views : 186

* CREATING A TABLE  *
CREATE TABLE  "CATEGORY_T"
   (    "CA_ID" NUMBER NOT NULL ENABLE,
    "CA_NAME" VARCHAR2(50),
    "LAST_MODIFIED_ON" DATE,
    "LAST_MODIFIED_BY" VARCHAR2(30),
     CONSTRAINT "CATEGORY_PK" PRIMARY KEY ("CA_ID") ENABLE
   )
/

* CREATING SEQUENCE *
 CREATE SEQUENCE   "CATEGORY_SEQ"  MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 100 CACHE 20 NOORDER  NOCYCLE
/

* CREATING TRIGGER *
CREATE OR REPLACE TRIGGER  "INSERT_CATEGORY"
BEFORE INSERT ON CATEGORY_T
FOR EACH ROW
DECLARE
  CA_id_sv number;
BEGIN
  IF INSERTING THEN
 
  :New.LAST_MODIFIED_ON:= SYSDATE;
  :New.LAST_MODIFIED_BY:= V('APP_USER');

  SELECT CATEGORY_SEQ.nextval
    INTO CA_id_sv
    FROM dual;
  :new.CA_ID := CA_id_sv;

  ELSIF UPDATING THEN

  :New.LAST_MODIFIED_ON:= SYSDATE;
  :New.LAST_MODIFIED_BY:= V('APP_USER');

END IF;
 
End;
/
 
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
34 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
» 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