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
- 11468 Views
- British Telecom BT, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ramya
select replace ('ABCD,EFGH,IJKL,PQRS',',','') from Customers;
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / obulesu
select length(regexp_replace('s,a,d,abc',','))
countofcharecter from dual
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nishi.swain@gmail.com
1.SELECT 'APPLE' STRING,LENGTH('APPLE') FROM DUAL;
2.SELECT ROWNUM RN FROM DUAL CONNECT BY ROWNUM<=100 MINUS SELECT ROWNUM RN FROM DUAL CONNECT BY ROWNUM<=49;
3.SELECT 'ABCD,EFGH,IJKL,PQRS'STRING,
REPLACE('ABCD,EFGH,IJKL,PQRS',',') FROM DUAL;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ajit nayak
1:-select length('apple')
from dual;
o/p:-5
2:-select rownum
from dual
connect by level between 50 and 100;
3:-select replace ('ABCD,EFGH,IJKL,PQRS',',')
from dual;
| Is This Answer Correct ? | 4 Yes | 5 No |
Answer / chiranjeevi
select level+49 from dual connect by level<=100
| Is This Answer Correct ? | 2 Yes | 3 No |
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
master table and child table performances and comparisons in Oracle ?
What is execute immediate in oracle?
In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What are the tools for Oracle ?
query optmization techniques and quwry analyser+projects+ppts
material view and view disadvantages?
How to connect the oracle server as sysdba?
what is the scripts in data base?
Difference between inner join vs where ?
Can we create index on views?
19 Answers CTS, Syntel, TCS,
Oracle General 
