Answer / nishi

A table is the basic unit of data storage in an Oracle database. The tables of a database hold all of the user accessible data. Table data is stored in rows and columns.

What are the different types of failures that occur in Oracle database?

0 Answers   HCL,

---

Explain the importance of .pll extension in oracle?

0 Answers  

---

Can sub procedure/function be called recursively?

0 Answers  

---

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

0 Answers  

---

what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?

1 Answers   Arrow Electronics,

---

how to tune oracle sql queries pls tell me step by step. urgent pls

1 Answers  

---

18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>

2 Answers   Wipro,

---

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

0 Answers   eicc,

---

Can you drop an index associated with a unique or primary key constraint?

0 Answers  

---

What are the factors causing the reparsing of SQL statements in SGA?

1 Answers  

---

What do you mean by merge in oracle and how can we merge two tables?

0 Answers  

---

How to delete a column in an existing table?

0 Answers  

---