Is truncate ddl or dml?

0 Answers  

---

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,

---

What do you understand by case manipulation functions?

0 Answers  

---

What is delimiter in pl sql?

0 Answers  

---

types of exceptions and what is meant by pragma autonomous_transaction ?what is the use.

4 Answers   3i Infotech,

---

---

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

0 Answers  

---

Let us suppose we have a table with structure in order empno empname empdesig empcountry and now i want to re-organize the columns of this table to empno empdesig empname empcountry how can i do this with queries ? assume that table contains the data.

3 Answers  

---

Can we rollback after truncate?

0 Answers  

---

Can I learn sql in a week?

0 Answers  

---

Is left join inner or outer by default?

0 Answers  

---

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

2 Answers  

---

I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?

1 Answers  

---