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*/
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
Is pl sql and postgresql same?
What is database sql?
What is snowflake sql?
what are the advantages of mysql in comparison to oracle? : Sql dba
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
Is sql better than access?
what are the performance and scalability characteristics of mysql? : Sql dba
what is the command used to fetch first 5 characters of the string? : Sql dba
How can we store rows in PL/SQL using array?
What normalization means?
What is the difference between truncate and drop statements?
Why is a trigger used?
what is a relationship and what are they? : Sql dba
Which constraints we can use while creating database in sql?
What is difference between pls_integer and integer?