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
- 11681 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
How to use select statement to count the number of rows in oracle?
What is oracle database 10g express edition?
What is the maximum number of triggers that can be applied to a single table?
When do I need to use a semicolon vs a slash in oracle sql?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
How to call a stored function with parameters?
What are privileges and grants?
How to get a list of all user accounts in the database?
What are the database administrators utilities available?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
What is Reduced List of Values?
Why do we need oracle client?
How to delete a column in an existing table?
What is the usage of control file in oracle?
What are triggers in oracle?
