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

Question Posted / deepakgunji

2 Answers
4552 Views
Wipro, I also Faced
E-Mail Answers

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

Post New Answer

More Oracle General Interview Questions

i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.

1 Answers MasterCard,

How to commit the current transaction in oracle?

0 Answers

What is a Schema ?

6 Answers

How do you tell what your machine name is and what is its IP address?

0 Answers

How to retrieve data from an explicit cursor?

0 Answers

Can we save images in a database and if yes, how?

0 Answers

Difference between open_form and call_form in oracle.

0 Answers

What is the difference between a hot backup and a cold backup in oracle?

0 Answers

Explain the use of ignore option in imp command.

0 Answers

What is difference between cartesian join and cross join?

0 Answers

Explain how are indexes update?

0 Answers

Explain about achiever in sql?

0 Answers

For more Oracle General Interview Questions Click Here