SV: Simple? PL/SQL query

From: Per Berghäll <Per.Berghall_at_linadb.se>
Date: Mon, 4 Sep 2000 16:12:05 +0200
Message-Id: <10609.116153@fatcity.com>

------_=_NextPart_001_01C0167A.1C3B70E0
Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi Sean,
You should enter: 'set serveroutput on;', before you run your code.

> Med v=E4nliga h=E4lsningar/ Kind regards

<<...>> Link=F6pings Adb-konsult AB
Per Bergh=E4ll
Adress: L=E5sblecksgatan 3

589 41 Link=F6ping
Tel : +46 (0)13-362600=20
Fax : +46 (0)13-362625
Email: mailto:per.berghall_at_linadb.se
Internet: http://www.linadb.se

> ----------
> Fr=E5n: O'Neill, Sean[SMTP:Sean.ONeill_at_organon.ie]
> Svara till: ORACLE-L_at_fatcity.com
> Skickat: Monday, September 04, 2000 4:41 PM
> Till: Multiple recipients of list ORACLE-L
> Ang=E5ende: Simple? PL/SQL query

>=20
> I'm new to PL/SQL and I am trying to use same to send output of name =
from
> v$database to screen. The code I'm using is as below but the output =
is
> not
> being sent to screen and I can't figure why not. The code is =
replying
> with
> "PL/SQL procedure successfully completed." in SQL*Plus. Maybe this =
is not
> the most appropriate way to approach this requirement and alternative
> method
> inputs are welcome too!. Are there any other ways to send output to
> screen
> aside from DBMS_OUTPUT?

>=20

> DECLARE

>=20

> db_name varchar2(20);

>=20


> BEGIN

>     SELECT name =20

>         INTO db_name

> 	FROM v$database;

>         DBMS_OUTPUT.PUT_LINE

>         ( 'Database name is ' || db_name );

> END;

>=20

> /

>=20
>=20

> Sean :)

>=20


> ######   ######  ######  ######=20

> #    #   #    #  #    #  #    #  Rookie

> ####     #    #  ######  ######  Data

> # # # # # # # # Base=20
> # # ####### ###### # # Adminstrator
> -------------------------------- ------------=20
> Organon (Ireland) Ltd.
> E-mail: sean.oneill_at_organon.ie [subscribed: Digest Mode]
>=20
> The only man who never makes a mistake is the man who never does =
anything.
> - Theodore Roosevelt

>=20

> --=20
> Author: O'Neill, Sean
> INET: Sean.ONeill_at_organon.ie

>=20


> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing =

Lists


> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>=20

------_=_NextPart_001_01C0167A.1C3B70E0
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>SV: Simple? PL/SQL query</TITLE>
</HEAD>
<BODY>

Hi Sean, You should enter: = 'set serveroutput on;', before you run your code.

Med v=E4nliga h=E4lsningar/ Kind = regards
 <FONT SIZE=3D2 FACE=3D"MS Sans =

Serif">**************************************************</FONT>

= <<...>> Link=F6pings Adb-konsult AB Per = Bergh=E4ll
 Adress: L=E5sblecksgatan 3
           &nbsp= ;    589 41 Link=F6ping Tel = : = +46 (0)13-362600 
 Fax = : = +46 (0)13-362625
 Email: <A =
HREF=3D"mailto:per.berghall_at_linadb.se">mailto:per.berghall_at_linadb.se</A>=

</FONT></U></B><B></B>
<BR><B><FONT COLOR=3D"#000080" SIZE=3D2 FACE=3D"MS Sans =
Serif">Internet:</FONT></B><B><U> <FONT COLOR=3D"#0000FF" SIZE=3D2 =

FACE=3D"MS Sans Serif"><A HREF=3D"http://www.linadb.se" = TARGET=3D"_blank">http://www.linadb.se</A> <FONT SIZE=3D2 FACE=3D"MS Sans =

Serif">**************************************************</FONT>
</P>
<UL>
<P><FONT SIZE=3D2 FACE=3D"MS Sans Serif">----------</FONT>

Fr=E5n:   = O'Neill, = Sean[SMTP:Sean.ONeill_at_organon.ie] Svara till: =     ORACLE-L_at_fatcity.com
 Skickat: =        Monday, September 04, 2000 4:41 PM Till:   = Multiple recipients of list = ORACLE-L
 Ang=E5ende: =       Simple? PL/SQL query

I'm new to PL/SQL and I am trying to = use same to send output of name from v$database to screen.  The code = I'm using is as below but the output is not being sent to screen and I can't = figure why not.  The code is replying with "PL/SQL procedure successfully = completed." in SQL*Plus.  Maybe this is not the most appropriate way to approach = this requirement and alternative method inputs are welcome too!.  Are = there any other ways to send output to screen aside from DBMS_OUTPUT?

DECLARE

db_name varchar2(20);

<P><FONT SIZE=3D2 FACE=3D"Arial">BEGIN</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;&nbsp;&nbsp; SELECT name&nbsp; =
</FONT>
<BR><FONT SIZE=3D2 =

FACE=3D"Arial">        INTO = db_name
         FROM v$database;
         = DBMS_OUTPUT.PUT_LINE
         ( 'Database = name is ' || db_name );
 END;

<P><FONT SIZE=3D2 FACE=3D"Arial">/</FONT>
</P>
<BR>

Sean :)

######   ######  = ######  ###### 
 #    #   = #    #  #    #  = #    #  Rookie ####     = #    #  ######  ######  Data #   #    = #    #  #    #  = #    #  Base #    #  = #######  ######  #    #  = Adminstrator

<BR><FONT SIZE=3D2 FACE=3D"Arial">-------------------------------- =

------------ 
 Organon (Ireland) Ltd. E-mail: = sean.oneill_at_organon.ie   [subscribed: Digest Mode]

The only man who never makes a mistake = is the man who never does anything.  - Theodore Roosevelt

<P><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Author: O'Neill, Sean</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp; INET: =

Sean.ONeill_at_organon.ie

Fat City Network = Services    -- (858) 538-5051  FAX: (858) = 538-5051
 San Diego, = California        -- Public Internet = access / Mailing Lists
 <FONT SIZE=3D2 =

FACE=3D"Arial">---------------------------------------------------------=

-----------
 To REMOVE yourself from this mailing = list, send an E-Mail message
 to: ListGuru_at_fatcity.com (note EXACT = spelling of 'ListGuru') and in
 the message BODY, include a line = containing: UNSUB ORACLE-L
 (or the name of mailing list you want = Received on Mon Sep 04 2000 - 09:12:05 CDT