DECLARE v_name VARCHAR2(40); v_user VARCHAR2(40); BEGIN SELECT * INTO v_name FROM global_name; SELECT user INTO v_user FROM dual; DBMS_OUTPUT.PUT_LINE(v_name); DBMS_OUTPUT.PUT_LINE(v_user); END; / column DATEREC format a25 column COLLDATE format a25 column COLLECTION_TIME format a20 column HOURS_OPERATED format a8 column MINUTES_OPERATED format a8 column COLLECTED_BY format a8 column FREQUENCY format a15 column text_value format a38 column ZONE# format a10 column TAP_LOCATION format a20 column PROD_BTW format a20 column FILTER format a20 column ADDRESS1 format a40 column ADDRESS2 format a40 column TOWN format a20 column JOB# format a20 column MISC format a40 column TREAT_TYPE format a20 column COMMENT1 format a40 column COMMENT2 format a40 column CHLORINATION# format a10 column COLLECTION_POINT format a30 column RECEIVED_BY format a10 column SAMPLE_TYPE format a40 column METHOD format a40 column METHOD_GETTER format a40 column Name format a48 ALTER SESSION SET GLOBAL_NAMES = FALSE; define _editor = textpad.exe define _editor = textpad SET SQLPROMPT 'COLD WEATHER SUX>' set linesize 200 set verify on set wrap off set array 100 SET COLSEP '|' set define on set pagesize 9999 set time on set null *NULL* set long 999 set longchunksize 999 set serveroutput on exec dbms_output.enable('100000000000'); cl scr