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 / 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 |
Post New Answer View All Answers
What is flashback in Oracle?
Please explain drop constraint oracle?
What is a initialization parameter file in oracle?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
What is the difference between PFILE and SPFILE in Oracle?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
What are the attributes of the cursor?
How to define an anonymous procedure without variables?
How to open and close an explicit cursor in oracle?
What do you understand by database schema and what does it hold?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Why oracle is used?
Why is oracle used?
What are the numeric comparison operations?
How to open a cursor variable?