Why do you use stored procedures and state some of its disadvantages?


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

Post New Answer

More Oracle General Interview Questions

There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.

2 Answers   Microsoft,


how can db_files > maxdatafiles since db_files is for instance and the later is for database

0 Answers   CTS,


how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

1 Answers   IBM,


Why we choose emp number as primarykey?

4 Answers  


How to login to the server without an instance?

0 Answers  






How to get execution path reports on query statements?

0 Answers  


What is literal?

0 Answers  


Explain the types of exception?

0 Answers  


Define Transaction ?

5 Answers  


What are the various oracle database objects?

0 Answers  


How to assign a table row to a record variable?

0 Answers  


How to use subqueries with the exists operator in oracle?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)