| simple question to answer [message #36709] |
Thu, 13 December 2001 17:36  |
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  |
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
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
