Oracle4A_Spool_Chen_Jason

Oracle4A_Spool_Chen_Jason - Jason Chen SQL>-Ch4ACase1A.sql...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
-- Jason Chen SQL> --Ch4ACase1A.sql SQL> SET SERVEROUTPUT ON SQL> DECLARE 2 curr_customer_first VARCHAR2(20) := 'Neal'; 3 curr_customer_last VARCHAR2(20) := 'Graham'; 4 curr_order_number NUMBER(4) := 1; 5 curr_order_date DATE := TO_DATE('5/29/06','MM/DD/YY'); 6 curr_customer_name VARCHAR2(40); 7 BEGIN 8 curr_customer_name := curr_customer_first ||' '||curr_customer_last; 9 DBMS_OUTPUT.PUT_LINE(curr_customer_name); 10 END; 11 / Neal Graham N PL/SQL procedure successfully completed. P SQL> -- Jason Chen SQL> --Ch4ACase1B.sql SQL> SET SERVEROUTPUT ON SQL> DECLARE 2 curr_customer_first VARCHAR2(20) := 'Neal'; 3 curr_customer_last VARCHAR2(20) := 'Graham'; 4 curr_order_number NUMBER(4) := 1; 5 curr_order_date DATE := TO_DATE('5/29/06','MM/DD/YY'); 6 order_message VARCHAR2(140); 7 BEGIN 8 order_message := 'Order# '|| curr_order_number ||' was placed on '|| TO_CHAR(curr_order_date, 'MM/DD/YY') ||' by '||curr_customer_first ||' '|| curr_customer_last; 9 DBMS_OUTPUT.PUT_LINE(order_message);
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/26/2010 for the course ITS 26 taught by Professor Jack during the Spring '10 term at Staten Island.

Page1 / 3

Oracle4A_Spool_Chen_Jason - Jason Chen SQL>-Ch4ACase1A.sql...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online