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
7370 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 an escape character in sql?

1018

How do I remove duplicates in two columns?

1048

How do I create a sql script?

1093

How to run pl sql program in mysql?

1009

Explain architecture of sql server notification services?

1051

What is the file extension for sql database?

996

Is sql a scripting language?

984

Does execute immediate commit?

1210

what are date and time functions in mysql? : Sql dba

969

what is collation? : Sql dba

1139

What is the least restrictive isolation level? : Transact sql

1057

How do I write a sql query in pgadmin 4?

969

What is your daily office routine?

2263

what is the difference between delete and truncate commands? : Sql dba

1058

What are the parts of a basic sql query?

960