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
- 6463 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 mariadb nosql?
Can a key be both primary and foreign?
How do you use collections in procedure to return the resultset?
Explain spool.
What is the difference between an inner and outer join?
What are predefined functions in sql?
What will you get by the cursor attribute sql%found?
Can we use the cursor's to create the collection in PL/SQL?
Mention what does plv msg allows you to do?
what is single byte over head in oracle..?
What is the difference between mdf and ndf files?
Can we have two clustered index on a table?
How to run sql statements through the web interface?
What is the difference between database trigger and stored procedure?
What is primary key secondary key alternate key candidate key?
