Virtual column
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