/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

8 votes228 views3 answers
Alter table auto_increment
SQL
13 votes241 views4 answers
Mysql select last 10 rows
SQL
8 votes237 views2 answers
Python simple connect to mysql
SQL
4 votes225 views2 answers
Select first and last row mysql
SQL
0 vote248 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
0 vote282 views1 answer
Sql trim whitespace
SQL
3 votes224 views3 answers
Mysql select table names
SQL
0 vote229 views1 answer
Postgresql add not null and not empty constraint
SQL
23 votes224 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
3 votes231 views3 answers
Sql current year
SQL