/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

7 votes119 views2 answers
Mysql get year from date
SQL
0 vote114 views1 answer
Sum sqlserver
SQL
0 vote147 views2 answers
Insert data into multiple tables mysql
SQL
1 vote125 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
0 vote140 views1 answer
How to define a non primary composite key in sql
SQL
-1 vote132 views1 answer
Ms sql select datetime as date
SQL
2 votes127 views1 answer
Where clause for child record apex
SQL
1 vote132 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
0 vote115 views1 answer
SQL Hello, [firstname] [lastname]
SQL
0 vote121 views1 answer
Cara menampilkan tabel yang tidak mengandung kata di sql server
SQL