/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

0 vote129 views1 answer
Sql shell psql cannot enter password
SQL
9 votes134 views5 answers
Sql delete duplicate rows but keep one
SQL
17 votes131 views3 answers
Postgresql version command
SQL
22 votes136 views3 answers
Remove all records from table mysql
SQL
4 votes125 views1 answer
Mysql timestamp in laravel migration
SQL
1 vote209 views1 answer
Mysql breakline on string
SQL
0 vote142 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
0 vote124 views1 answer
Find usage of table in sql server
SQL
4 votes140 views1 answer
Postgresql create table with index
SQL
0 vote127 views1 answer
Alter precision
SQL