Home » SQL & PL/SQL » SQL & PL/SQL » simple question to answer
simple question to answer [message #36709] Thu, 13 December 2001 17:36 Go to next message
Johnny
Messages: 15
Registered: October 2000
Junior Member
thanks for everyones help the last 2 question i have are what does 'var_least_price := null' mean an do
and whatwhat does dbms_output.put_line do.

thanks

----------------------------------------------------------------------
Re: simple question to answer [message #36723 is a reply to message #36709] Fri, 14 December 2001 06:21 Go to previous message
SAlapati
Messages: 12
Registered: November 2001
Junior Member
the var_least_price is an variable to which you are assigning a NULL value.

dbms_output is the standard oracle package
and put_line is one of the procedures inside the dbms_output package.

So all the dbms_output.put_line does is print the string you provide to the output screen.

for example

SQL> execute dbms_output.put_line ('hello world');
PL/SQL procedure successfully completed.

sorry I forgot to do this first
SQL> set serveroutput on
SQL> execute dbms_output.put_line ('hello world');

(now you will see the following)

hello world

PL/SQL procedure successfully completed.

hope this helps
SAlapati

----------------------------------------------------------------------
Previous Topic: how to use macro in sqlplus
Next Topic: What is "i" in oracle 8i/9i
Goto Forum:
  


Current Time: Thu Aug 06 09:04:08 CDT 2020