Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11480 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
What do you mean by group by clause?
How to recover a dropped table in oracle?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What is a view and how is it different from a table?
How do you tell what your machine name is and what is its IP address?
Explain about integrity constraint?
How to resolve name conflicts between variables and columns?
query optmization techniques and quwry analyser+projects+ppts
What is bulk collect in oracle?
6. Display the client name and order date for all orders using the traditional method.
Give syntax for SQL and ORACLE joins.
Differentiate between pre-select and pre-query?
How to write a query with an inner join in oracle?
How to concatenate two text values in oracle?
