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
7401 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 are sql indexes?

1001

What is a crud api?

954

What is multiple partition?

967

How to set up sql*plus output format in oracle?

1038

how to create a new view in mysql? : Sql dba

938

What is the use of sql trace?

952

How do I run a pl sql program?

1130

how can we destroy the session, how can we unset the variable of a session? : Sql dba

1000

What is the difference between unique and primary key constraints?

1071

What is rtm stands for?

1100

What is difference between ms sql and mysql?

964

what is the use of friend function? : Sql dba

1023

What is flag in sql?

1035

How do I run a sql query?

1022

What does t sql mean?

949