Answer / Ajit Kumar Sharma

Yes, SQL*Loader allows you to filter data during the loading process using WHERE clauses in the control file. This enables you to selectively load only the records that meet specific criteria.

What is pl/sql tables?

7 Answers   TCS,

---

If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.

4 Answers   Saama Tech, TCS,

---

What are Lexical Parameters.How They are used in Reports 6i

2 Answers   eicc,

---

What is meant by temporal data?

1 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  

---

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

1 Answers  

---

What is normalization and types of normalization?

22 Answers   Etisbew, F-TEC, Microsoft, TechProcess,

---

What is pl sql in oracle?

1 Answers  

---

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1 Answers  

---

How do u count no of rows in a table?

8 Answers   CTS,

---

How do I run a query in pl sql developer?

1 Answers  

---

Write the sql query using dual table for below output? 1 L R --- --- ---- 1 1 1 1 2 1 1 3 1 1 1 2 1 2 2 1 3 2 1 1 3 1 2 3 1 3 3 Write a query using only Dual table with out writing any pl/sql program.

3 Answers   JPMorgan Chase,

---