How does stored procedure reduce network traffic?


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

Post New Answer

More SQL PLSQL Interview Questions

How many primary keys can a table have?

0 Answers  


What is data modelling in sql?

0 Answers  


What is Histogram?

0 Answers   NIIT,


Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

0 Answers  


What are the types of join and explain each?

0 Answers  






i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that.example jan has 4 weeks i need 1st dd for evry wk

1 Answers   Aspire,


What are all types of user defined functions?

0 Answers  


What is sql exception?

0 Answers  


Can we create view in stored procedure?

0 Answers  


What do we need to check in database testing?

0 Answers  


Store procedure will return a value?

4 Answers   eMids,


What are the two types of exceptions in pl/sql?

0 Answers  


Categories