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
- 7512 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 many clustered indexes can you have?
What is mutating sql table?
what is the difference between delete and truncate commands? : Sql dba
What are %type and %rowtype for?
What is a null value?
What is anonymous block in sql?
what is the syntax used for partition in tsql? : Transact sql
what is data control language? : Sql dba
How do I view a view in sql?
What is view explain with example?
how many sql ddl commands are supported by 'mysql'? : Sql dba
What is rownum in sql?
What is pl sql and why it is used for?
Difference between table function and pipelined function?
What is a relationship and what are they?
