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
- 7371 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 consistent is the view of the data between and within multiple sessions, transactions or statements ?
What is the most restrictive isolation level? : Transact sql
what is a table in a database ? : Sql dba
how can we submit a form without a submit button? : Sql dba
What will you get by the cursor attribute sql%notfound?
What is a procedure in pl sql?
What is the difference between python and sql?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
How many sql commands are there?
What is the process of debugging?
What are the advantages of sql?
What does the argument [or replace] do?
What are the different operators available in sql?
What are the most important ddl statements in sql?
Why we use cross join?
