Answer / Kuldeep

Oracle PL/SQL packages consist of three main components: package specifications, package bodies, and private types. The specification declares variables, procedures, functions, and exceptions that can be accessed from outside the package. The body defines their implementation. Private types are user-defined data types used to encapsulate related data.

Can I learn sql in a week?

1 Answers  

---

Write a pl/sql script to display the following series of numbers: 99,96,93……9,6,3?

1 Answers  

---

What is cursor explain with example?

1 Answers  

---

Which one is better subquery or joins?

1 Answers  

---

Talk about views

10 Answers   Polaris,

---

Which is better cte or subquery?

1 Answers  

---

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the "sales_detail" table contains ten records with different values in the flavor column (two "vanilla," three "chocolate," four "strawberry," and one NULL), how many rows are returned by the sample code above? 1. 0 rows 2. 1 row 3. 3 rows 4. 4 rows 5. 10 rows

8 Answers   Sonata,

---

What are all the different normalization?

1 Answers  

---

How do you remove duplicate records from a table?

1 Answers  

---

If a cursor is open, how can we find in a pl/sql block?

0 Answers  

---

What is a relationship and what are they?

1 Answers  

---

Explain table and field in sql?

1 Answers  

---