What is MTTR advisor in Oracle?
- 0 Answers
- 608 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 update values in a table in oracle?
Point the difference between translate and replace?
List the parts of a database trigger.
What is the relationship among database, tablespace and data file?
How a tablespace is related to data files?
What are the Referential actions supported by FOREIGN KEY integrity constraint ?
How to find out what privileges a user currently has in oracle?
What does `(+)` do in a where clause?
How to sort output in descending order in oracle?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
how to i write the query 'NISHI' TO N I S H I
4 Answers Attra, Metric Stream,
Oracle General 
