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*/
Answers were Sorted based on User's Feedback
As you said that DBMS_OUTPUT.PUT_LINE should not be used in given piece of your program, so it can be done by creating a procedure by name print as follows
create or replace procedure print(n number)
as
begin
dbms_output.put_line(n) ;
end ;
and then executing your piece of code i.e.
declare
a number:=2;
begin
print(a);
end;
Hope this is what u r question reflects ?
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / 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 |
What are aggregate and scalar functions?
what are the different tables present in mysql? : Sql dba
Explain the difference between 'between' & 'and' operators in sql
How can I delete duplicate rows?
When sql appeared?
What is record variable?
How do I start pl sql?
What is the purpose of using pl/sql?
How do you update a sql procedure?
What is the use of primary key?
When the mutating error will comes? and how it will be resolved?
What is the difference between joins?