overloading of stored procedure is possible in oracle?

3 Answers   Nelco,

---

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers   Wipro,

---

How to run sql statements with oracle sql developer?

0 Answers  

---

Is trigger a stored procedure?

0 Answers  

---

Is join same as left join?

0 Answers  

---

Explain the concept of normalization.

3 Answers  

---

how do you count the duplicate records in a table

10 Answers   Tech Mahindra,

---

What are all ddl commands?

0 Answers  

---

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  

---

Does sql use python?

0 Answers  

---

how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  

---

How do I write a sql query in pgadmin 4?

0 Answers  

---