Answer / Priyanka Varshney

To convert a date to Julian date format in PL/SQL, use the 'JULIAN' function:nnDBMS_OUTPUT.PUT_LINE(JULIAN(SYSDATE));

What are the blocks in stored procedure?

6 Answers   Microsoft,

---

What is Difference Between delete and Truncate?

9 Answers  

---

How to retrieve a second highest salary from a table? Note:Suppose salaries are in duplicate values eg: Name Sal Malli 60000 Pandi 60000 Rudra 45000 Ravi 45000

10 Answers   Mind Tree, Polaris, Sonata,

---

What are pl/sql packages?

1 Answers  

---

how can we know the count/number of elements of an array? : Sql dba

1 Answers  

---

how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900

8 Answers  

---

what is the purpose of update command in oracle?

7 Answers   MBT,

---

What is the purpose of design view?

1 Answers  

---

What is localdb mssqllocaldb?

1 Answers  

---

How many clustered indexes can be created on a table?

1 Answers  

---

Can we insert data into view?

1 Answers  

---

SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 Answers  

---