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
Why cross join is used?
What does where 1 1 mean in sql?
How do I add a database to sql?
What is the advantage of index in sql?
What is the usage of sql functions?
What are different types of indexes?
what is the difference between char and varchar data types? : Sql dba
Write the alter statement to enable all the triggers on the t.students table.
Can we alter stored procedure?
What is difference between sql and excel?
How is sql used in oracle?
How can I delete duplicate rows?
what is try_catch block in procedure
Which is better cte or subquery?
What are sql commands?