What is the difference between substr & instr functions?
No Answer is Posted For this Question
Be the First to Post Answer
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
Can sub procedure/function be called recursively?
What are the common oracle dba tasks?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How to list all tables in your schema?
Give the Types of modules in a form?
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
How to create lov dynamically at runtime & attach to text field?
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?
Which is better Oracle or MS SQL? Why?
Explain a data segment?
What privilege is needed for a user to create views in oracle?