Answer / Munindra Kumar Mishra

"To customize the output format in SQL++ for Oracle, use the SET command. For example, to display column headings only once and to set field width for a specific column:

```sql
SET NEWPAGE 0 HEADING OFF FEEDBACK OFF TRIMOUT ON PAGE 99 LINESIZE 120 COLUMN col_name FORMAT A15"""

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1 Answers  

---

I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.

4 Answers   GE,

---

What are the different types of a subquery?

1 Answers  

---

What are the different operators available in sql?

1 Answers  

---

What are the types of queries in sql?

1 Answers  

---

Explain commit, rollback and savepoint.

1 Answers  

---

Delete duplicate records in the emp table.

6 Answers   Oracle,

---

How to load data with sql*loader?

1 Answers  

---

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

1 Answers  

---

How many columns should be in an index?

1 Answers  

---

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

1 Answers   IBM,

---

What is java sql drivermanager?

1 Answers  

---