Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7400 Views
- iFlex, I also Faced
- E-Mail Answers
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
What packages are available to pl/sql developers?
What are the disadvantages of file system?
What is rownum?
What is a full join sql?
What is blind sql injection?
Write a sql query to get the third highest salary of an employee from employee_table?
What is the use of count (*) in sql?
how to enter numeric values as hex numbers? : Sql dba
Can I call a procedure inside a function?
How do I start sql profiler?
What is the current version of postgresql?
How do you declare a variable in pl sql?
What is crud sql?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
What is form and report?
