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
- 7498 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
How do I view tables in sql developer?
what is online transaction processing (oltp)? : Sql dba
What is auto increment feature in sql?
What is the command used to fetch the first 5 characters of a string?
Is sql a scripting language?
How to create an array in pl/sql?
What is the location of pre_defined_functions.
what is the stuff function and how does it differ from the replace function? : Sql dba
What is the difference between having clause and where clause?
Can dml statements be used in pl/sql?
What is microsoft t sql?
Which tcp/ip port does sql server run?
Can we write ddl statements in functions?
What is meant by temporal data?
What is sql clause?
