What are the benefits of stored procedures?


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

Post New Answer

More SQL PLSQL Interview Questions

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,


Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

0 Answers  


What are properties of the transaction?

0 Answers  


Does pl/sql support create command?

0 Answers  


What is sql data?

0 Answers  






Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.

5 Answers   Thomson,


What is a 'instead of trigger'?

3 Answers   Eenadu, TCS,


What is transaction control language (tcl)?

0 Answers  


Why coalesce is used in sql?

0 Answers  


Explain mutating table error.

0 Answers  


how can you see all indexes defined for a table? : Sql dba

0 Answers  


write a query to delete similar records in same table

13 Answers   TCS,


Categories