Answer / Prakasha M

"To get help at the SQL++ prompt in Oracle, use the HELP or ? command. For example:

```sql
HELP SET;
```

What is faster join or subquery?

1 Answers  

---

What is online transaction processing (oltp)?

1 Answers  

---

what is difference between procedure and function

10 Answers   MCN Solutions, Wipro,

---

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

---

Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.

9 Answers   Oracle,

---

What is oracle and pl sql?

1 Answers  

---

What is bulk compiling in pl/sql.?

1 Answers   MCN Solutions,

---

what does the t-sql command ident_incr does? : Transact sql

1 Answers  

---

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

4 Answers   JDA,

---

what is log shipping? : Sql dba

1 Answers  

---

oracle is compiler or interpretter,can any one tell me the answer?

9 Answers   Satyam,

---

Explain dml and ddl?

1 Answers  

---