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*/
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 the purpose of primary key?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
What are predefined functions in sql?
What is the syntax and use of the coalesce function?
how to create a test table in your mysql server? : Sql dba
how to use like conditions? : Sql dba
write an sql query to find names of employee start with 'a'? : Sql dba
How do you determine the current isolation level? : Transact sql
what is sql in mysql? : Sql dba
What is mutating error?
Explain the update statement in sql
What are the sql commands?
What is parameter substitution in sql?
What is pls_integer in pl sql?
What is the usage of nvl function?