/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 vote274 views1 answer
Display first three characters sql
SQL
4 votes292 views1 answer
For loop postgresql
SQL
0 vote269 views4 answers
Sql year
SQL
0 vote276 views1 answer
Select last N rows mysql
SQL
0 vote288 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
0 vote228 views1 answer
Oracle function select into
SQL
8 votes318 views6 answers
Insert command in sql
SQL
0 vote291 views1 answer
How to get specific salary in sql
SQL
0 vote269 views1 answer
Initcap in sql
SQL
3 votes278 views1 answer
Ssh check mysql version
SQL