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"
- 7 Answers
- 9762 Views
- British Telecom BT, I also Faced
- E-Mail Answers
Answer Posted / phani kumar
1:-select length('apple')from dual;
2:-select level+50 from dual connect by level<=51;
3:-select replace ('ABCD,EFGH,IJKL,PQRS',',')from dual;
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Explain integrity constraint?
What is meant by joins? List out the types of joins.
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
Give the constructs of a package, function or a procedure.
What is an oracle user role?
What is private procedure oracle?
How to connect ms access to oracle servers?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
Difference between open_form and call_form in oracle.
Is a rollback possible to any savepoint?
Explain what are the type of synonyms?
Explain the use of rows option in imp command.
What is a user role in oracle?
Why does Oracle not permit the use of PCTUSED with indexes?
