Interested to Buy Any Domain ? << Click Here >> for more details...
What are the advantages and disadvantages, compared to the
standard SQL and SQL*plus ?
- 2 Answers
- 12883 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Can variables be used in sql statements?
What are the advantages of stored procedure?
How do I edit a trigger in sql developer?
what are the different index configurations a table can have? : Sql dba
what is the difference between a having clause and a where clause? : Sql dba
How to create your own reports in sql developer?
What is the difference between an inner join and an outer join?
Is sql microsoft?
How can we debug in PL/SQL?
Which language is used in sql?
Can we use ddl statements in stored procedure sql server?
what is schema? : Sql dba
Explain 3 basic parts of a trigger.
How can you get sql*loader to commit only at the end of the load file? : aql loader
how to calculate expressions with sql statements? : Sql dba
