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   iFlex,

---

What are the different ways to optimize a sql query?

0 Answers  

---

Begin For j in 4403201000 .. 4403202000 Loop If mod (j, 100) = 0 then Dbms_output.put_line (j); End if; End loop; End; what will be the output of this question

7 Answers   TCS,

---

How do I run sql?

0 Answers  

---

How to add a column ‘salary’ to a table employee_details?

0 Answers  

---

What is execute immediate?

0 Answers  

---

Differentiate between sga and pga.

0 Answers  

---

What is Referential Integrity?

3 Answers  

---

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

0 Answers   Satyam,

---

Why do we create stored procedures & functions in pl/sql and how are they different?

0 Answers  

---

what is difference between "Primary key" and "Unique key"?

4 Answers   PreVator,

---

package specification-3 procedures package body-4 procedures how can i write for other procedure in package body

2 Answers   Reliance,

---