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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center