Answer / chandrika

•Applications that involve extensive business logic and
processing could place an excessive load on the server if
the logic was implemented entirely in stored procedures.
Examples of this type of processing include data transfers,
data traversals, data transformations and intensive
computational operations. You should move this type of
processing to business process or data access logic
components, which are a more scalable resource than your
database server.
•Do not put all of your business logic into stored
procedures. Maintenance and the agility of your application
becomes an issue when you must modify business logic in T-
SQL. For example, ISV applications that support multiple
RDBMS should not need to maintain separate stored
procedures for each system.
•Writing and maintaining stored procedures is most often a
specialized skill set that not all developers possess. This
situation may introduce bottlenecks in the project
development schedule.

Answer / shaik

Hi,

1.sql is structured quiery language 1.sql plus is an
interfacing tool or medium through

sql statements will be passed to the oracle server.
2.Sql keywords cannot be abbreviated 2.sql plus cannot be
abbreviated.

thanks
Shaik

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,

---

What is trigger with example?

0 Answers  

---

Is id a reserved word in sql?

0 Answers  

---

What is an implicit commit?

0 Answers  

---

How do I make my sql query run faster?

0 Answers  

---

What is AUTH_ID and AUTH_USER in pl/sql ?

0 Answers   INDUS,

---

What is the purpose of primary key?

0 Answers  

---

where are cookies actually stored on the hard disk? : Sql dba

0 Answers  

---

What are wait events. Describe the wait event tables.

1 Answers   CTS,

---

How many scalar data types are supported in pl/sql?

0 Answers  

---

Can you join a table to itself?

0 Answers  

---

How can you save or place your msg in a table?

0 Answers  

---