What are the advantages and disadvantages, compared to the
standard SQL and SQL*plus ?
Answers were Sorted based on User's Feedback
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.
Is This Answer Correct ? | 3 Yes | 1 No |
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
Is This Answer Correct ? | 5 Yes | 7 No |
How to install oracle sql developer?
What is difference between stored procedures and application procedures?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
How many triggers can be applied on a table?
Describe sql comments?
how tsql statements can be written and submitted to the database engine? : Transact sql
Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.
In what condition is it good to disable a trigger?
Define sql delete statement.
Difference between SUBSTR and INSTR?
What are the default Oracle triggers??
What can be a size of a pl/sql block? Is there any limit?