OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » sql problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sql problem [message #41247]

Thu, 12 December 2002 01:04

Gurdeep Singh
Messages: 64
Registered: October 2002

Member

declare
begin
for i in 1..10
loop
dbms_output.put('*');
end loop;
end;
/
above code does't give any output
i what to print output

**********

but it does't work, please tell me how i print this.

Report message to a moderator

Re: sql problem [message #41252 is a reply to message #41247]

Thu, 12 December 2002 06:02

B
Messages: 327
Registered: August 1999

Senior Member

dir u set in sql*plus:

set severoutput on

???

Report message to a moderator

Re: sql problem [message #41255 is a reply to message #41247]

Thu, 12 December 2002 06:43

Gurdeep Singh
Messages: 64
Registered: October 2002

Member

i already set
set serveroutput on
but it does't work

Report message to a moderator

Re: sql problem [message #41270 is a reply to message #41255]

Thu, 12 December 2002 10:54

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

Change the PUT call to PUT_LINE.

Report message to a moderator

Previous Topic:	Avoding duplicate records - URGENT
Next Topic:	Sequence question, pls help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 18:38:08 CDT 2024