We have to create procedure for print and called the SP for print any m

write a procedure to print a statement or number not
using "dbms_output.put_line" package.write a procedure
instead of it using procdure name as "print"
ex:-

declare
a number:=2;
begin
print(a);
end;
/* when U type above procedure 2 have to should be printed*/

Question Posted / amit kumar(patna)

2 Answers
7500 Views
iFlex, I also Faced
E-Mail Answers

Answer Posted / amit kumar(patna)

We have to create procedure for print and called the SP for print any message
create or replace procedure print(n varchar)
as
begin
dbms_output.put_line(n) ;
end ;

set serveroutput on
declare
a number;
begin
a:=20;
print(a);
end;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is type and rowtype in pl sql?

1055

What normalization means?

1014

What is cursor in pl sql with examples?

1086

How do I order by ascending in sql?

1076

How to get unique records from a table?

1019

What is varchar used for?

1133

what is oracle database ? : Sql dba

1078

What are different types of sql?

1258

what are the different type of normalization? : Sql dba

1064

How many databases can sql express handle?

1028

What is oracle pl sql developer?

1021

Does google use sql?

1003

How do you rename a table in sql?

1180

Why coalesce is used in sql?

1063

Which query operators in sql is used for pattern matching?

1005