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

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

Question Posted / deepakgunji

2 Answers
4769 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 is shell?

2 Answers Microsoft,

How do I reset a sequence in oracle?

How to save query output to a local file?

please explain.. DB architecture ...

what is the difference between data migration and production migration.

Explain the use of show option in imp command.

Please explain oracle data types with examples?

Maximum how many triggers can be updated in table ?

5 Answers Accenture, Cap Gemini,

What is an Oracle sequence?

What is an oracle database?

Why do we need integrity constraints in a database?

Explain oracle data types with examples?

For more Oracle General Interview Questions Click Here

Categories

Oracle General (1803)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)
Oracle Security (38)
Oracle Forms Reports (510)
Oracle Data Integrator (ODI) (120)
Oracle ETL (15)
Oracle RAC (93)
Oracle D2K (72)
Oracle AllOther (241)