Answer / 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 ?

Answer / amit kumar(patna)

We have to create procedure for print and called the SP for print any message
create or replace procedure print(n varchar)
as
begin
dbms_output.put_line(n) ;
end ;

set serveroutput on
declare
a number;
begin
a:=20;
print(a);
end;

Why do we need view in sql?

0 Answers  

---

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

0 Answers  

---

What are different types of sql commands?

0 Answers  

---

What does subquery mean in sql?

0 Answers  

---

what is the difference between group by and order by in sql? : Sql dba

0 Answers  

---

write a query to display diference between two dates in sql server

2 Answers  

---

What is a behavioral trigger?

0 Answers  

---

With out using count() function. How to the find total number of rows in a table?

6 Answers  

---

Does postgresql run on the cloud?

0 Answers  

---

How do I delete a trigger?

0 Answers  

---

Explain what is a view?

0 Answers  

---

Can two tables have same primary key?

0 Answers  

---