/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 vote321 views1 answer
Liquibase update row
SQL
0 vote347 views1 answer
Default order by in mysql
SQL
0 vote293 views1 answer
Grant owner postgresql
SQL
0 vote362 views2 answers
Postgres isnull
SQL
0 vote552 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
0 vote321 views1 answer
Show size of all tables postgres
SQL
-1 vote320 views1 answer
MYSQL stored procedure select from
SQL
0 vote354 views1 answer
Hue hive UploadingTextFiletoHive
SQL
0 vote304 views1 answer
Automate mysql cli query
SQL
0 vote322 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL