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 / chandra shekhar
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 |
Post New Answer View All Answers
How do I upgrade sql?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
What does pl sql stand for?
How can you select unique records from a table?
What is pl/sql table? Why it is used?
Can we create view in stored procedure?
What is sql lookup?
What are all the ddl commands?
Can we use delete in merge statement?
How to change sql*plus system settings?
Is sql a dbms?
what is a unique key ? : Sql dba
what is the stuff function and how does it differ from the replace function? : Sql dba
how many groups of data types? : Sql dba
What is the mutating table and constraining table?