How many objectname will be created for a single table drop
function? Why 'flashback' query giving error "ORA-38312:
original name is used by an existing object" while getting
the table?


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

Post New Answer

More Oracle General Interview Questions

how to retrieve 1st and last row of table without using group functions??

6 Answers  


How to connect to a remote server?

0 Answers  


How to handle a single quote in oracle sql?

0 Answers  


difference between bind variable and variable

1 Answers   Attra,


What is oracle host variable?

0 Answers  






Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.

3 Answers  


Can a Tablespace hold objects from different Schemes ?

3 Answers  


How to rename an existing table?

0 Answers  


Can group functions be mixed with non-group selection fields?

0 Answers  


Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

0 Answers   Microsoft,


How to call a stored function in oracle?

0 Answers  


Can I create users through internet explorer in oracle 10g?

0 Answers   MCN Solutions,


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)