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

Question Posted / deepakgunji

2 Answers
4638 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

What are steps required to ENTER DATA INTO DWH?

2 Answers

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

0 Answers

How to insert multiple rows with one insert statement in oracle?

0 Answers

What are the data types in oracle?

0 Answers

what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval

2 Answers

How to generate query output in html format?

0 Answers

How to pass a cursor variable to a procedure?

0 Answers

Explain database link?

0 Answers

I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????

1 Answers

What is memory advisor in Oracle?

0 Answers MCN Solutions,

how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group

2 Answers Verizon,

What is recovery manager(rman) backup in Oracle?

0 Answers MCN Solutions,

For more Oracle General Interview Questions Click Here