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;

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

0 Answers  

---

What is implicit cursor in pl sql?

0 Answers  

---

explain what is mysql? : Sql dba

0 Answers  

---

What is window clause?

1 Answers   TCS,

---

What is schema in sql example?

0 Answers  

---

What is serial sql?

0 Answers  

---

Is json a nosql?

0 Answers  

---

How do I count rows in sql?

0 Answers  

---

Is vs as in pl sql?

0 Answers  

---

What is equi join in sql?

0 Answers  

---

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,

---

How to start oracle sql developer?

0 Answers  

---