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

ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

2 Answers  

---

Write a query to find the names of users that begin with "um" in sql?

0 Answers  

---

What is clustered, non-clustured and unique index. How many indexes can be created on a table ?

3 Answers   TCS,

---

What are the different set operators available in sql?

0 Answers  

---

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

0 Answers  

---

What is a constraint? Tell me about its various levels.

0 Answers  

---

What are the parameter modes supported by pl/sql?

0 Answers  

---

what are wild cards used in database for pattern matching ? : Sql dba

0 Answers  

---

Is not null in sql?

0 Answers  

---

Can there be 2 primary keys in a table?

0 Answers  

---

write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35

1 Answers   TCS,

---

What is the difference between delete and truncate statement in sql?

0 Answers  

---