Re: PL/SQL v. SQL*PLUS v. SQL*REPORTWRITER
Date: 26 Aug 1993 06:00:32 GMT
Message-ID: <25hji0INNkr8_at_gap.caltech.edu>
secrist_at_kxovax.enet.dec.com (Strong datatypes for weak minds.) writes:
>What is the high-level difference between PL/SQL, SQL*PLUS, and
>SQL*REPORTWRITER ? SQL*PLUS seems like it could be a pretty
>good reporter writer on its own from my cursory reading.
PL/SQL has no i/o capability (V1)
I've made PL/SQL V2 create output against RDBMS 7.0.12 data
using a packaged procedure named "dbms_output"
Example>
BEGIN
dbms_output.enable (9000); /* enable the output package */
status := 'Enabled dbms_output.';
dbms_output.put_line (status); /* debug */
select count(ename) into count_ename from emp;
dbms_output.put_line ('count_ename is: 'count_ename);
END;
/
SQL*PLUS is good; I've become familiar with it. you can simulate variables with the following syntax:
column x new_value variable
select sysdate x from dual;
select name, sdate from shipdates
where sdate > to_date(&variable);
I like SQL*REPORTWRITER if I'm in a hurry to put together a master-detail report with a date & title at the top.
-Dan
Daniel B. Bikle
Independent Oracle Consultant
dbikle_at_alumni.caltech.edu
415/854-9542
Received on Thu Aug 26 1993 - 08:00:32 CEST