/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 vote198 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote201 views7 answers
Les jointures sql server
SQL
0 vote210 views1 answer
Sql python hwo to pass a list in paramerter
SQL
5 votes208 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
0 vote207 views1 answer
Sql server user permissions and roles
SQL
6 votes189 views1 answer
Rank function in oracle with example
SQL
8 votes214 views1 answer
Oracle search stored procedures for text
SQL
-1 vote210 views1 answer
Ssms connect with connection string
SQL
1 vote221 views1 answer
Postgresql datetrunc too slow
SQL
0 vote197 views1 answer
Run mssql server terminal
SQL