Are stored procedures faster than queries?


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

Post New Answer

More SQL PLSQL Interview Questions

what is the use of double ampersand (&&) in sql queries?

0 Answers  


What is the maximum size of sqlite database?

0 Answers  


How can I make sql query run faster?

0 Answers  


What is the maximum number of triggers,can apply to a single table?

2 Answers  


Can ddl statements be used in pl/sql?

0 Answers  






HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM

3 Answers  


Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,


What are the modes of parameters that can be passed to a procedure ?

3 Answers  


How many functions are there in sql?

0 Answers  


Why do we create stored procedures & functions in pl/sql and how are they different?

0 Answers  


What are the two types of cursors in pl sql?

0 Answers  


How to create an array in pl/sql?

0 Answers  


Categories