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
- 7241 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
What is composite data type in pl sql?
how to get @@error and @@rowcount at the same time? : Sql dba
How many types of tables are there?
Explain about various levels of constraint.
Can a procedure in a package be overloaded?
What is trigger and how to use it in sql?
what is collation? : Sql dba
how mysql optimizes distinct? : Sql dba
What is form and report?
How many types of cursors are available in pl/sql?
What are all ddl commands?
What are the built in functions of sql?
Which is better stored procedure or query?
What is an ndf file?
How are sql commands classified?
