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 do you understand by pl/sql cursors?
What is primary and foreign key?
what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...
What is a sql instance vs database?
What is the difference between an inner and outer join?
What is difference between hql and native sql?
How you will create Toad Function?
How do I pipe the output of one isql to another?
Describe the Index, Types of index, At what situation we have used? Which one s better than others?
I have a procedure in a procedure. The inner procedure contains out parameter. How I can call the inner procedure in the out procedure and send the inner procedure parameter value(out parameter value) into out procedure?
What is difference between hql and sql?
What is the advantage of nosql?