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,

---

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

0 Answers  

---

How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?

2 Answers   Fidelity,

---

How to trace the errors in pl/sql block code?

5 Answers   TCS,

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

0 Answers  

---

how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?

4 Answers   TCS,

---

What is the difference between explicit and implicit cursors in oracle?

0 Answers  

---

What is localdb mssqllocaldb?

0 Answers  

---

What is diff between bulk collect and forall

3 Answers   Metric Stream,

---

Explain how procedures and functions are called in a PL/SQL block ?

3 Answers  

---

What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?

2 Answers  

---

Types of indexes. What is the default key created when a primary key is created in a table ?

5 Answers   TCS,

---