/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

1 vote332 views2 answers
Mysql join two tables
SQL
3 votes349 views3 answers
Create table in microsoft sql server
SQL
0 vote342 views1 answer
Permission denied postgres \copy csv command line
SQL
0 vote369 views1 answer
Sparql list all graphs
SQL
0 vote316 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
1 vote360 views2 answers
Extract weekday from date in sql
SQL
57 votes536 views6 answers
Sql alter table
SQL
4 votes399 views4 answers
Check constraint in ms sql
SQL
0 vote301 views1 answer
Create duplicate table in postgresql
SQL
5 votes325 views1 answer
Oracle asynchronous query
SQL