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*/
- 2 Answers
- 6465 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
how to run 'mysql' commands from a batch file? : Sql dba
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
What do you understand by pl/sql packages?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
how to convert numeric values to character strings? : Sql dba
What is pl sql block in dbms?
Can we join same table in sql?
What is sql resultset?
What is bind reference and how can it be created?
Why do we use procedures in sql?
How can you view the errors encountered in a trigger?
What is the basic structure of an sql?
Is join same as left join?
Why do we need pl sql?
Can we create foreign key without primary key?
