/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 vote300 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
0 vote227 views1 answer
Oracle sql developer closed connection
SQL
0 vote230 views1 answer
Start stop mysql linux
SQL
0 vote254 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote210 views1 answer
Plpgsql if statement
SQL
1 vote224 views1 answer
Date_part mysql
SQL
0 vote224 views1 answer
SQL: calculate hours from two dates
SQL
0 vote235 views1 answer
Oracle insert single quote in string
SQL
0 vote214 views1 answer
Sql create text column limited values
SQL
19 votes213 views2 answers
Mysql add column after another
SQL