How to rename an index in oracle?


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

Post New Answer

More Oracle General Interview Questions

How to view the data files in the current database?

0 Answers  


Display Odd/ Even number of records?

3 Answers  


Can we use bind variables in oracle stored procedure?

0 Answers  


How to bring a tablespace offline?

0 Answers  


What are the differences between lov and list item?

0 Answers  


What are the major difference between truncate and delete?

0 Answers  


how will I find the first 5 highest salaried employees in each dept in oracle.

22 Answers   IBM,


create or replace procedure show_tab_rec ( P_tab VARCHAR2 ) IS cmd varchar2(50); begin cmd := 'select * from '|| P_tab; for int in ( execute immediate cmd ) loop dbms_output.put_line ( int.ename||' '||int.deptno); end loop; end; when i m compling this procedure i m getting this error PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following: . ( ) , * @ % & | = - + < / > at in is mod remainder not range rem => .. <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ PLZ solve this error give this question answer asap Thanks advance.......

1 Answers   HCL,


Indexes in oracle ?

3 Answers   Keane India Ltd, L&T,


Explain what are the uses of rollback segment?

0 Answers  


What are the factors causing the reparsing of SQL statements in SGA?

1 Answers  


What is the difference between "as" and "is" in an oracle stored procedure?

0 Answers  


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