anony.sql

学习PL/SQL时收集的一些经典的SQL源代码

DECLARE
  v_weight 		NUMBER(3) := 600;
  v_message 		VARCHAR2(255) := 'Product 10012';
  v_new_locn		VARCHAR2(50):='china';
BEGIN
    dbms_output.put_line('1**'||to_char(v_weight)||'**'||v_message||'**'||v_new_locn);

    DECLARE
      v_weight 		NUMBER(3) := 1;
      v_message 	VARCHAR2(255) := 'Product 11001';
      v_new_locn 	VARCHAR2(50) := 'Europe';
    BEGIN
	v_weight   := v_weight + 1;
	v_new_locn := 'Western '|| v_new_locn;
    dbms_output.put_line('2**'||to_char(v_weight)||'**'||v_message||'**'||v_new_locn);
    END;

	v_weight   := v_weight + 1;
	v_message  := v_message || ' is in stock';
	v_new_locn := 'Western '|| v_new_locn;

    dbms_output.put_line('3**'||to_char(v_weight)||'**'||v_message||'**'||v_new_locn);
END;
/