Question

5
Replies
1745
Views
Close popover
Teruyuki Shimizu (shimt)
PEGA
Sr. System Architect
Pegasystems Inc.
JP
shimt Member since 2016 4 posts
PEGA
Posted: May 31, 2016
Last activity: June 16, 2016
Closed
Solved

Data type on Oracle DB for currency, boolean and phone property inside Pega7.2

I'm creating tables on Oracle DB for inserting PageList data inside Pega7.2.

The PageList has a currency, boolean and phone type property.

What type should I use inside Oracle for creating a table?

Pega                        Oracle

   Text(Single line)       Varchar2(100 byte)

   Integer                    NUMBER(15,0)

   Date only                Date

   Currency                ?????

   Boolean                  ?????

   Phone                     ?????

ex)

CREATE TABLE "YAKUJO_MOTO"

   ("YAKUJOYMD" DATE,

  "TORIATSUKAITSUKA" VARCHAR2(100 BYTE),

  "YAKUJONO" NUMBER(15,0),

  "HAKKOTAIKYOJUKBN" VARCHAR2(100 BYTE),

  "TORIHIKISYURUI" VARCHAR2(100 BYTE),

  "HAKKOTAIKOKUSEKI" VARCHAR2(100 BYTE),

  "SYOKENSYURUI" VARCHAR2(100 BYTE),

  "MEIGARAMEI" VARCHAR2(100 BYTE),

  "SYOKENCHOTANKBN" VARCHAR2(100 BYTE),

  "YAKUJOTORIHIKIKBN" VARCHAR2(100 BYTE),

  "SHOKENTSUKA" VARCHAR2(100 BYTE),

Thank you for your help in advance,

Teruyuki

Data Integration
Moderation Team has archived post