Question

5
Replies
1407
Views
shimt Member since 2016 4 posts
PEGA
Posted: 4 years ago
Last activity: 4 years 3 months ago
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
Share this page LinkedIn