/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 vote192 views1 answer
Mysqldump ignore table
SQL
0 vote203 views1 answer
Select list is not in group by clause and contains nonaggregated column codeigniter
SQL
0 vote287 views1 answer
Mysql readable output
SQL
0 vote298 views1 answer
Multiple replace value mssql
SQL
1 vote185 views1 answer
Copy postgres table from one schema into another
SQL
0 vote234 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
38 votes277 views4 answers
Count sql
SQL
11 votes199 views2 answers
Insert current date sql
SQL
5 votes783 views1 answer
Oracle ora-00054 find
SQL
3 votes192 views2 answers
Oracle sql drop sequence
SQL