What are a collation and state the different types of collation sensitivity?
No Answer is Posted For this Question
Be the First to Post Answer
What is data type in oracle?
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.
does the query needs a hint to access a materialized view?
what is the exact diiference between DBMS and RDBMS
What is a Segment ?
What are the different windows events activated at runtime ?
What is a table index?
What is currency type in database ?
How to use attributes of the implicit cursor in oracle?
When do you get a .pll extension in oracle?
what is data abstraction
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar