How to drop a stored procedure in oracle?



How to drop a stored procedure in oracle?..

Answer / Asha Kumari

"DROP PROCEDURE procedure_name;"

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle General Interview Questions

What is the data pump import utility?

1 Answers  


What is a partition in oracle?

1 Answers  


How would you best determine why your MVIEW couldnt FAST REFRESH?

1 Answers  


what is trigger?

6 Answers   Oracle,


How to download oracle database 10g xe?

1 Answers  


What is a Garbage Collection? and what is full recursive Garbage collection?

1 Answers   RBS,


Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1 Answers   Wipro,


In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

1 Answers  


How to use existing values in update statements using oracle?

1 Answers  


Without giving condition how to retrieve the unmatched records from table.

1 Answers   TCS,


what r routers?

1 Answers  


What are set operators?

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1803)
  • 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)