Message-Id: <10610.116200@fatcity.com> From: "Allan Nelson" Date: Tue, 5 Sep 2000 07:54:45 -0500 Subject: Re: Simple? PL/SQL query If you are running this in SQL*Plus then issue set serveroutput on before executing your code. Allan ----- Original Message ----- From: "O'Neill, Sean" To: "Multiple recipients of list ORACLE-L" Sent: Monday, September 04, 2000 9:41 AM Subject: 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); > > BEGIN > SELECT name > INTO db_name > FROM v$database; > DBMS_OUTPUT.PUT_LINE > ( 'Database name is ' || db_name ); > END; > > / > > > Sean :) > > ###### ###### ###### ###### > # # # # # # # # Rookie > #### # # ###### ###### Data > # # # # # # # # Base > # # ####### ###### # # Adminstrator > -------------------------------- ------------ > Organon (Ireland) Ltd. > E-mail: sean.oneill@organon.ie [subscribed: Digest Mode] > > The only man who never makes a mistake is the man who never does anything. > - Theodore Roosevelt > > -- > Author: O'Neill, Sean > INET: Sean.ONeill@organon.ie > > 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@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).