Interested to Buy Any Domain ? << Click Here >> for more details...
What is index in Oracle?
- 0 Answers
- 1081 Views
- MCN Solutions, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
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.
How to insert a new row into a table in oracle?
What is the difference between normal and corelated subqueries?
What is set operator oracle?
What is Data Dictionary Cache in Oracle?
is there a tool to trace queries, like profiler for sql server?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
Explain the relationship among Database, Tablespace and Data file?
What is Public Database Link ?
What is a snapshot log?
What are the types of Database Links ?
How do you handle duplicate records in a database?
Oracle General 
