write a query to count number of alphabets in given string
for example "APPLE"
write a query to generate sequence from 50 to 100
write a query to display in single string "ABCD,EFGH,IJKL,PQRS"
Answer Posted / obulesu
select length(regexp_replace('s,a,d,abc',','))
countofcharecter from dual
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a read only transaction in oracle?
How to write date and time interval literals in oracle?
How to add a new column to an existing table in oracle?
What is the usage of synonyms?
What is oracle database 10g express edition?
What are temporal data types in oracle?
How to delete a column in an existing table in oracle?
Explain the use of control file?
Is the After report trigger fired if the report execution fails ?
What to do if the binary spfile is wrong for the default instance?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
How to use windows user to connect to the server?
What is a server parameter file in oracle?
How to create a table interactively?