Answer Posted / guest

Its bad to see that Questions are not asked properly, and next is, people are not answering correctly, but no one is questioning them back.

Eg:- What is pragma exception and how, when, where us ...

Shaik --
Its not a Pre compiled exception, it is a Compiler Directive which has special meaning to this keyword.

Amit Kumar--
The Error range is from -20000 to -20999

Ramesh--
Your question is not clear.
eg:-How it compiler find?....

Guys Please be serious, as this is a good place to learn and share knowledge. Anyone who is really looking for interview questions will get wrong answers in their preparation

regards
j

What is the difference between partitioning and sharding?

989

---

What is the need of a partition key?

972

---

How to run sql statements through the web interface?

1020

---

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1080

---

How do I run a query in pl sql developer?

975

---

Why is sql better than hql?

970

---

Which is faster subquery or join?

1191

---

Is inner join faster than left join?

1172

---

List out the acid properties and explain?

940

---

How to download oracle sql developer?

1086

---

What is pl sql architecture?

945

---

What is right join in sql?

1076

---

How do you update a sql procedure?

1011

---

What are the different types of tables in sql?

975

---

Explain the types of joins in sql?

1015

---