Answer / roopesh kumar

Yes we can write pl/sql code directly in package. This
process is known as package initialisation. In this we can
write the code direct in package body in the end of body.

Answer / a.jyothsna

In package body we can write ..
But in package specification also we can write

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

---

Can we use join in subquery?

0 Answers  

---

What are actual parameters and formal parameters?

0 Answers  

---

describe mysql connection using mysql binary. : Sql dba

0 Answers  

---

explain access control lists. : Sql dba

0 Answers  

---

---

Is progress software supports to ( pl/sql )?

0 Answers  

---

what are the advantages of package?

7 Answers   iFlex,

---

What is trigger in sql? Explain

0 Answers  

---

how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used

11 Answers   UST,

---

How to select random rows from a table?

0 Answers  

---

Is sqlite good enough for production?

0 Answers  

---

How is indexing done in search engines?

0 Answers  

---