What is the difference between substr & instr functions?


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

Post New Answer

More Oracle General Interview Questions

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

0 Answers  


Can sub procedure/function be called recursively?

0 Answers  


What are the common oracle dba tasks?

0 Answers  


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  


How to list all tables in your schema?

0 Answers  






Give the Types of modules in a form?

1 Answers  


what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?

2 Answers  


How to create lov dynamically at runtime & attach to text field?

0 Answers  


1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?

2 Answers   Accenture,


Which is better Oracle or MS SQL? Why?

2 Answers   Bally Technologies,


Explain a data segment?

0 Answers  


What privilege is needed for a user to create views 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)