/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

7 votes328 views6 answers
Group_concat mysql
SQL
4 votes362 views1 answer
Sql select limit range
SQL
1 vote332 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL
4 votes347 views4 answers
What is primary key
SQL
0 vote342 views1 answer
Resullt all update knex mysql
SQL
3 votes329 views3 answers
Remove all spaces from string sql
SQL
0 vote345 views1 answer
Oracle webcenter content search enginer
SQL
2 votes339 views4 answers
List databases in sql server
SQL
23 votes330 views4 answers
Sql server substring
SQL
0 vote350 views1 answer
Top 3 salary in sql
SQL