DPSP
Contacts About Us


Powered by Dynamic PSP

Click here to view a Desperado Demo

-- Drop the old instance of T$LOOKUP
DROP TABLE t$lookup
/

CREATE TABLE t$lookup
    (id                             NUMBER NOT NULL,
    lookup_type                    NUMBER NOT NULL,
    code                           VARCHAR2(2000) NOT NULL,
    description                    VARCHAR2(4000),
    pos                            NUMBER,
    parent_id                      NUMBER,
    owner_id                       NUMBER,
    status                         NUMBER(1,0) NOT NULL
  ,
  CONSTRAINT T$LOOKUP_PK
  PRIMARY KEY (id)
  USING INDEX
  PCTFREE     10
  INITRANS    2
  MAXTRANS    255
  STORAGE   (
    INITIAL     65536
    MINEXTENTS  1
    MAXEXTENTS  2147483645
  ))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  STORAGE   (
    INITIAL     65536
    MINEXTENTS  1
    MAXEXTENTS  2147483645
  )
CACHE
/


-- End of DDL Script for Table T$LOOKUP

-- Start of DDL Script for Table T$LOOKUP_TYPE

-- Drop the old instance of T$LOOKUP_TYPE
DROP TABLE t$lookup_type
/

CREATE TABLE t$lookup_type
    (id                             NUMBER NOT NULL,
    name                           VARCHAR2(2000) NOT NULL,
    parent_id                      NUMBER,
    owner_id                       NUMBER
  ,
  CONSTRAINT T$LOOKUP_TYPE_PK
  PRIMARY KEY (id)
  USING INDEX
  PCTFREE     10
  INITRANS    2
  MAXTRANS    255
  STORAGE   (
    INITIAL     65536
    MINEXTENTS  1
    MAXEXTENTS  2147483645
  ))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  STORAGE   (
    INITIAL     65536
    MINEXTENTS  1
    MAXEXTENTS  2147483645
  )
CACHE
/


-- Triggers for T$LOOKUP_TYPE

CREATE OR REPLACE TRIGGER before_change_t$lookup_type
 BEFORE
  INSERT OR UPDATE
 ON t$lookup_type
REFERENCING NEW AS NEW OLD AS OLD
 FOR EACH ROW
begin
  :new.name := upper(:new.name);
end;
/

-- End of DDL Script for Table T$LOOKUP_TYPE

Click here to view a Desperado Demo

How to run the demo
How to run the demo
Login
Login Procedure
CLOB TO BLOB
Clob to Blob converter
BLOB TO CLOB
Blob to Clob converter
CLOB TO ARRAY
Clob to Array converter
Universal Lookup
Universal Lookup based on DPSP can save your time to create a large application, based on several types of lookups. This is only two tables and you can create a unlimited lookups and do not need to create several procedures to support application data.
Hello World!
Simple example
List of objects
How to create a striped report
Hot parameters
You can supply a number of parameters in URL string
Sample dialog form
How to use input items in dialogs
Your own code
Here you can create your own example of PSP code from scratch
Calendar
How to create a simple calendar by means of DPSP
CalendarLink
How to create a simple calendar by means of DPSP
email us
Copyright © 2000-2017 by HitMedia LLC. All Rights Reserved.