Answer / Pankaj Balodi

To convert a date into Julian format using SQL, you can use the function JULIAN() which returns the number of days elapsed since November 24th, 4713 B.C., considered to be day 0 in the Julian calendar. Example: SELECT JULIAN('2022-01-01')

what is blob? : Sql dba

1 Answers  

---

Why do we use cursors?

1 Answers  

---

What is a variable in sql?

1 Answers  

---

If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 Answers  

---

What is view? Can we update view

1 Answers  

---

Why schema is used in sql?

1 Answers  

---

Why is normalization important?

1 Answers  

---

what is row? : Sql dba

1 Answers  

---

what is log shipping? : Sql dba

1 Answers  

---

What do you mean by query optimization?

1 Answers  

---

Two Methods of retrieving SQL?

7 Answers   Atiric Software, Microsoft, Oracle, TCS, Wipro,

---

what are the limitations of identity column? : Transact sql

1 Answers  

---