Breaking News: Grepper is joining You.com. Read the official announcement!

oracle call a function in a insert statement

Add Answer

answered on March 30, 2020 Popularity 9/10 Helpfulness 1/10

answer oracle call a function in a insert statement

related oracle insert into

related insert into oracle

oracle call a function in a insert statement

Comment

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;

Popularity 9/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: call function insert-statement oracle sql

Link to this answer
Share Copy Link

Contributed on Jan 06 2022

0 Answers Avg Quality 2/10

Closely Related Answers

oracle insert into

Comment

INSERT INTO table
(column1, column2, ... column_n )
VALUES
(expression1, expression2, ... expression_n );

Popularity 10/10 Helpfulness 5/10 Language sql

Source: www.techonthenet.com

Tags: insert-into inse

Link to this answer
Share Copy Link

Contributed on Mar 30 2020

Grotesque Goat

0 Answers Avg Quality 2/10

oracle insert into

Comment

INSERT INTO table
(column1, column2, ... column_n )
SELECT expression1, expression2, ... expression_n
FROM source_table
[WHERE conditions];

Popularity 10/10 Helpfulness 3/10 Language sql

Source: www.techonthenet.com

Tags: insert-into inse

Link to this answer
Share Copy Link

Contributed on Mar 30 2020

Grotesque Goat

0 Answers Avg Quality 2/10

insert into oracle

Comment

-2

INSERT INTO contacts
(contact_id, last_name, first_name, address)
VALUES
(1000, 'Smith', 'Jane', '10 Somewhere St.');

Popularity 9/10 Helpfulness 1/10 Language sql

Source: www.techonthenet.com

Tags: insert-into inse

Link to this answer
Share Copy Link

Contributed on Dec 13 2022

Juan Camilo Rodriguez

0 Answers Avg Quality 2/10

oracle call a function in a insert statement

Contents

More Related Answers

oracle call a function in a insert statement

Closely Related Answers

oracle insert into

oracle insert into

insert into oracle

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.