PL/SQL (MOSC)

MOSC Banner

Virtual column

edited Aug 19, 2017 5:00AM in PL/SQL (MOSC) 4 commentsAnswered

Hi all

I do have a table and i want to build the virtual column

SQL> desc pr_lrs.issuance

Name                                      Null?    Type

----------------------------------------- -------- ----------------------------

PMT_AMT                                            NUMBER(10,2)

ID                                                 NUMBER

EDBC_ID                                            NUMBER

CREATED_BY                                         VARCHAR2(30)

UPDATED_BY                                         VARCHAR2(30)

CREATED_ON                                         TIMESTAMP(6)

UPDATED_ON                                         TIMESTAMP(6)

CAT_CODE                                           VARCHAR2(3)

VEND_PMT_ID                                        NUMBER

PERS_ID                                            NUMBER

ORG_ID                                             NUMBER

AID_CODE                                           VARCHAR2(3)

ISSUE_COUNTY_CODE                                  VARCHAR2(3)

CITY_NAME                                          VARCHAR2(50)

LINE_1_ADDR                                        VARCHAR2(50)

LINE_2_ADDR                                        VARCHAR2(50)

STATE_CODE                                         VARCHAR2(3)

ZIP_CODE_SUFFIX                                    VARCHAR2(4)

ZIP_CODE_NUM                                       VARCHAR2(32)

RELATED_ISSUANCE_ID                                NUMBER

EFF_DATE                                           DATE

PGM_ID                                             NUMBER

PMT_REQ_ID                                         NUMBER

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center