13. Display the second to fifth characters in each client name.

Question Posted / deepakgunji

Answers were Sorted based on User's Feedback

13. Display the second to fifth characters in each client name...

Answer / devraj

Select Substr(ename, 2,4), ename From emp;

Is This Answer Correct ?

9 Yes

0 No

13. Display the second to fifth characters in each client name...

Answer / nanne

SELECT SUBSTR(ENAME, 2, 4), ENAME FROM EMP;

Is This Answer Correct ?

0 Yes

0 No

More Oracle General Interview Questions

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

Explain what are the different type of segments?

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

What privilege is needed for a user to create indexes in oracle?

What is a data dictionary and how can it be created?

Describe the types of sub query?

what happened to the global index when I truncate the data in one of the partition?

What is hot backup and logical backup?

Can a View based on another View ?

What is key preserved table?

How to bring a tablespace offline?

How to write a left outer join with the where clause in oracle?

For more Oracle General Interview Questions Click Here