/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 vote112 views1 answer
Show mysql account privilleges
SQL
0 vote116 views1 answer
Mysql show foreign keys column
SQL
0 vote118 views1 answer
Postgres populate table from another table
SQL
1 vote122 views1 answer
Oracle list data files
SQL
0 vote113 views1 answer
Flexible search query delete table
SQL
2 votes121 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
2 votes130 views3 answers
Copy data from one table column to another table column in sql
SQL
0 vote113 views1 answer
R2dbc-postgresqldriver dependency
SQL
2 votes76 views1 answer
Foreign key example in dbms
SQL
0 vote74 views1 answer
How to connect sql server using ip address in c#
SQL