/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 vote362 views1 answer
Date in where on datetime column clause mysql
SQL
0 vote353 views1 answer
Sql server roles and users
SQL
0 vote335 views1 answer
Select value from previous row in postgresql
SQL
5 votes376 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
7 votes369 views3 answers
Convert ansi sql
SQL
0 vote354 views1 answer
Sort by last two number sql
SQL
1 vote357 views1 answer
Mysql select for update ejemplo
SQL
0 vote337 views1 answer
Postgresql conectar
SQL
0 vote303 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
31 votes331 views3 answers
Sql count
SQL