How to find the duplicate rows count from employees table in oracle?
How to list all indexes in your schema?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
What are the uses of linked server and explain it in detail?
How do we get field details of a table?
What does sharding mean?
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.
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What is an oracle and why it is used?
What are the different types of failures that occur in Oracle database?
What is Private Database Link ?
Can we use bind variables in oracle stored procedure?
What is Partitions in Table ?