How to define an anonymous procedure without variables?


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

Post New Answer

More Oracle General Interview Questions

i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.

1 Answers   MasterCard,


Is there an oracle sql query that aggregates multiple rows into one row?

0 Answers  


How does oracle handle read consistency?

0 Answers  


How to remove a row in a database table?

5 Answers   IBM,


How to define and use table alias names in oracle?

0 Answers  






What are the different type of Segments ?

2 Answers  


normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

0 Answers   iFlex,


What is the use of aggregate functions in oracle?

0 Answers  


How to display First 4 rows From Database Table?

6 Answers  


What is clustered table in Oracle?

0 Answers   MCN Solutions,


What is a view and how is it different from a table?

0 Answers  


How to get maxsal , minsal, ename department wise in single query

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)