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
- 7419 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
Is join an inner join?
What is sql integrity?
How to set up sql*plus output format in oracle?
How do I make my sql query run faster?
What is a clob in sql?
What is dcl in sql?
Can we use having without group by in sql?
Can a table contain multiple foreign key’s?
What are sql functions? Describe in brief different types of sql functions?
Why partition by is used in sql?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
What is normalisation in sql?
Can we call procedure in select statement?
What is parameter substitution in sql?
Differentiate between pl/sql and sql?
