/SQL/Oracle call a function in a insert statement

Oracle call a function in a insert statement

FUNCTION mfi_cust_details(vacid VARCHAR2) return my_table%ROWTYPE as 
  my_table%ROWTYPE vcustdetails;
BEGIN
  SELECT a.cust_title_code,
    a.cust_id,
    b.address_line1,
    b.address_line2,
    mfi_citycountry (b.country, b.city),
    b.zip
  INTO vcustdetails 
  FROM tbaadm.cmg a, crmuser.address b
            WHERE TRIM (a.cif_id) = TRIM (b.orgkey)
              AND UPPER (b.addresscategory) IN ('MAILING', 'REGISTERED')
              AND cust_id IN (SELECT cust_id
                              FROM tbaadm.gam
                              WHERE acid = vacid);  

  RETURN vcustdetails;
END;

Source: stackoverflow.com

Similar codes

2 votes170 views2 answers
How to check database username and password in postgresql
SQL
0 vote196 views1 answer
Hue hive UploadingTextFiletoHive
SQL
36 votes197 views3 answers
Add column in mysq
SQL
0 vote169 views1 answer
List mysql tables and views
SQL
0 vote175 views1 answer
How to write if case in select query in select statement
SQL
0 vote182 views1 answer
Mysql command line top 10
SQL
0 vote176 views1 answer
Why we have to set the password for my sql server
SQL
1 vote165 views1 answer
Postgres count string length
SQL
2 votes169 views1 answer
Mysql query unique column
SQL
36 votes228 views6 answers
Change column data type sql
SQL