Answer / neel armstrong

Julian date is the number of days from 01-Jan-4712 BC

Answer / ajay

days since 31 Dec 4713

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 is sql procedures and functions?

0 Answers  

---

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

9 Answers   TCS,

---

Where can I learn sql for free?

0 Answers  

---

Name some usages of database trigger?

0 Answers  

---

What is query execution plan in sql?

0 Answers  

---

What is full join?

0 Answers  

---

When is a declare statement required?

0 Answers  

---

What is the main reason behind using an index?

0 Answers  

---

Which function is used to return remainder in a division operator in sql?

0 Answers  

---

what is global variable in package

3 Answers   Polaris,

---

what are all the different types of indexes? : Sql dba

0 Answers  

---