alter table STG_TBLDISRUPTIONS add stg_hash as  ORA_HASH (INTINTERNALID  ||  VCHIMSNO  ||  CHRFANDDNO  ||  INTINCIDENTNO  ||  VCHDESCRIPTIONFAULT 
 ||  TININCIDENTTYPEID  ||  TINLINEID  ||  DTMINCIDENTFAULTSTARTDATETIME  ||  DTMNOTIFICATIONDATETIME 
 || DTMSTARTDATETIME  ||  DTMENDDATETIME  ||  DTMACTUALENDDATETIME  ||  DTMDURATIONENDDATETIME 
 ||   CHRFROMBRSSTATIONID  ||  CHRTOBRSSTATIONID  ||  VCHLOCATIONDESC  ||  CHRDIRECTIONID  ||  SINEXTRARUNNINGTIME 
 ||   CHRPLATFORMNO  ||  BLNMULTIPLESIGNAL  ||  TINNOOFPEOPLETRAPPED  ||  CHRMODEOFFAILURE  ||  TINDAYOFWEEKTABLEID 
 ||  TINTYPEOFSTATIONCLOSUREID  ||  BLNHEADWAY  ||  BLNPRIMARY  ||  BLNBOOKEDACCESS  ||  BLNNODEFECTFOUND 
 ||  BLNREASONABLENOTIFICATION  ||  DECNACHSVALUE  ||  BLNUSEDINPAYMENT  ||  DTMUSEDINPAYMENT  ||  TINCLOSEDPERIOD 
 ||  INTCLOSEDYEAR  ||  DECPAYMENTNACHSVALUE  ||  DECPREVIOUSPAYMENTNACHSVALUE  ||  TINIMSATTRIBUTIONID  ||  VCHASSETNUMBER  ||  INTASSETTYPEID  ||  TINFRCATEGORYID  ||  CHRPERFORMANCESPECCATEGORY 
 ||  VCHDESCRIPTIONCLEARANCE  ||  SINSPECIALCLEARANCETIME  ||  CHRREASONFORCLEARANCE  ||  DTMEXTENDEDCLEARANCEDATETIME 
 || VCHINITIALNOTIFREPORTEDBY   ||  VCHINITIALNOTIFREPORTEDTO  ||  DTMTRANSFERINDATETIME  ||  TINFRCSENDERID  ||  TINFRCTRANSFERREDTO 
 ||  VCHCLEARANCEREPORTEDBY  ||  VCHCLEARANCEREPORTEDTO  ||  CHRCONSEQUENTIALINCIDENT  ||  TINIMPORTORIGINID  ||  TINIRF  ||  TININFRACOCONTACTID  ||  INTFRCNO  || 
  VCHFRCDESCRIPTIONFAULT  ||  VCHFRCDESCRIPTIONCLEARANCE  ||  DTMFRCNOTIFICATIONDATETIME  ||  VCHFRCINITIALNOTIFREPORTEDBY  ||  DTMFRCCLEARANCEDATETIME  ||  VCHFRCCLEARANCEREPORTEDBY 
 ||  BLNCHANGEDDETAILS  ||  BLNCOVERRISK  ||  DTMDATETOUSEFORCOVERRISK  ||  SINCAUSECODEID  ||  SINSERVICECODEID  ||  VCHCONNECTCONTRATORPARTY  ||  DTMCONNECTCONTRATORNOTIFIEDDT  ||  INTSERVICEPOINTS  ||  TINASSETGROUPID 
 ||  DTMDATERECORDADDED  ||  TINTYPEOFASSETNUMBERID  ||  VCHUNITNUMBER  ||  BLNREPORTRECEIVED  ||  TINKPI2ALLOCATIONID  ||  TINKPI2TIME  ||  VCHTRAINNO  ||  VCHINCIDENTREPORTMANAGER 
 ||  VCHINFRACOREFNO  ||  TINAREACODEID  ||  INTBRSSTATIONSERVICECODEID  ||  BLNSTATIONDISRUPTION  ||  TINCURRENTSTATUSID  ||  TINCURRENTATTRIBUTIONID  ||  VCHDISRUPTIONCURRENTLEVEL  ||  BLNCONTRAVENTION  ||  BLNTEMPUPDATE  || 
     BLNNACHSLEGITIMATEZERO  ||  VCHUSERRECORDADDED  ||  VCHSPEEDRESTRICTID  ||  INTDURATIONMINUTES  ||  BLNNACHSNOTRUN  ||  BLNENGOVERRUN  ||  INTENGOVERRUNSERVICEPOINTS  ||  BLNRPTRCVDWITHINTWENTYFOURHRS  ||  VCHEFOLDERID  ||  VCHLCFOLDER  || 
     VCHLASTUPDATEDBY  ||  DTMLASTUPDATED  ||  TINTIMEBANDID  ||  INTEXTENDEDTYPEID  ||  TINNACHSSTATUS  ||  INTHALLID  ||  INTROUTEID  || 
     INTPLSSURROGATEID  ||  INTLINESECTIONID  ||  TINRESTRICTEDSPEED  ||  INTAFFSTARTDISTANCE  ||  INTAFFENDDISTANCE  ||  INTLORID  ||  CHRDEGRADEDMODE 
 ||  BLNSERVICEHOURSOVERRIDE  ||  TINPLSCOLUMNUSED  ||  BLNONEWAY  ||  DTMMODELLEDENDDATETIME  ||  VCHSTARTPLATFORM  ||  VCHFINISHPLATFORM  ||  VCHVIAROUTE  ||  INTDETRAINMENTSTATIONID  ||  VCHOTHERSTARTPLATFORM  ||  VCHOTHERFINISHPLATFORM  || 
     VCHOTHERVIAROUTE  ||  BLNBOTHDIRECTIONS  ||  BLNSINGLEPOINTFAILURE  ||  BLNHOTSPARE  ||  VCHLOSSOFROUTEID  ||  BLNTDRREDUCTION );
     

SQL> select  *
  2    from  v$version
  3  /

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE    10.2.0.5.0      Production
TNS for 64-bit Windows: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production

SQL> create table tbl
  2    as
  3      select  *
  4        from  hr.employees
  5        where rownum <= 5
  6  /

Table created.

SQL> create index tbl_idx1
  2    on tbl(first_name || ' ' || last_name)
  3  /

Index created.

SQL> select  column_name
  2    from  user_tab_cols
  3    where table_name = 'TBL'
  4      and virtual_column = 'YES'
  5  /

COLUMN_NAME
------------------------------
SYS_NC00012$

SQL> column full_name format a30
SQL> select  first_name,
  2          last_name,
  3          sys_nc00012$ full_name
  4    from  tbl
  5  /

FIRST_NAME           LAST_NAME                 FULL_NAME
-------------------- ------------------------- ------------------------------
Donald               OConnell                  Donald OConnell
Douglas              Grant                     Douglas Grant
Jennifer             Whalen                    Jennifer Whalen
Michael              Hartstein                 Michael Hartstein
Pat                  Fay                       Pat Fay

SQL>