if a string is there like s1,s2,s3,s4.How to find count of
commas in this.
Answer Posted / ashok
SELECT LENGTH(REGEXP_REPLACE('s1,s2,s3,s4', '[s0-9]', '')) FROM dual
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What does an inner join do?
Can %notfound return null after a fetch?
what is foreign key? : Sql dba
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
Mention what is the plv (pl/vision) package offers?
What is an ndf file?
Why is a primary key important?
how to escape special characters in sql statements? : Sql dba
How to process query result in pl/sql?
What is sql*loader?
What does the sign mean in sql?
What is trigger and types?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
How do I filter in sql profiler?
What are packages in pl sql and also explain its advantages?