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

How long will it take to learn pl sql?

892

---

How do you copy a table in sql?

1015

---

What is nested table in pl sql?

1007

---

what is the syntax used for partition in tsql? : Transact sql

960

---

Explain the purpose of %type and %rowtype data types?

876

---

Is sql difficult?

1107

---

What is data abstraction in sql?

969

---

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1135

---

How do I start sql profiler?

943

---

what is the syntax for using sql_variant_property? : Transact sql

990

---

What is a recursive join sql?

1027

---

What pl/sql package consists of?

1033

---

What is the difference between drop and truncate commands?

999

---

What is a constraint?

963

---

What are all the different normalizations?

972

---