explain the advantages and disadvantages of stored procedure? : Sql dba


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

Why plvtab is considered as the easiest way to access the pl/sql table?

0 Answers  


What is numeric function sql?

0 Answers  


When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?

2 Answers   Accenture, Unisoft Infotech,


HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.

16 Answers  


How is data stored in sql?

0 Answers  






How do I run a sql query?

0 Answers  


Why do you partition data?

0 Answers  


need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

1 Answers  


Do stored procedures prevent sql injection?

0 Answers  


i want to display 1 to 10 numbers using one select statement.

18 Answers   HCL, Nyros, Oracle,


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

3 Answers   TCS,


What is dialect in sql?

0 Answers  


Categories