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;

Is merge a dml statement?

0 Answers  

---

What is the difference between mdf and ndf files?

0 Answers  

---

what is the syntax used for partition in tsql? : Transact sql

0 Answers  

---

What are the types of index in sql?

0 Answers  

---

Does sql full backup truncate logs?

0 Answers  

---

What is update query?

0 Answers  

---

How many columns should be in an index?

0 Answers  

---

How many indexes can be created on a table in sql?

0 Answers  

---

can we call a procedure from a function?

9 Answers   Mind Tree,

---

What are the advantages of indexing?

0 Answers  

---

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the "sales_detail" table contains ten records with different values in the flavor column (two "vanilla," three "chocolate," four "strawberry," and one NULL), how many rows are returned by the sample code above? 1. 0 rows 2. 1 row 3. 3 rows 4. 4 rows 5. 10 rows

8 Answers   Sonata,

---

what is pragma ?

1 Answers   Polaris,

---