Liren Large Software Subsidy 5/05.iso/a/a524/37.ddi/demo/demo3_pls.sql

Text File | 1991-03-04 | 434 b | 13 lines

rem
rem $Header: demo3_pls.sql,v 6.1 90/02/16 18:40:06 nsalah Exp $ demo3_pls.sql Copyr (c) 1989 Oracle
rem
DECLARE
    prod_name   inventory_table.product%TYPE;
        /* prod_name will automatically have the same length **
        **  as the inventory_table.product column.           */
BEGIN
    SELECT product INTO prod_name FROM inventory_table
      WHERE prod_id = 2741;
    INSERT INTO temp(message) VALUES (prod_name);
END;