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

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

Question Posted / nanne

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

Answer Posted / nanne

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

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between post-database commit and post-form commit?

1165

What are the extensions used by oracle reports?

1024

How to bring a tablespace online?

1061

What is the quickest way to export a table to a flat file?

952

What is an anonymous block?

1218

What is a table in oracle?

969

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5392

What is redo log?

1042

what is the difference between substr and instr function in oracle?

1067

How to establish administrator authentication to the server?

1023

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2437

How much memory your 10g xe server is using?

1087

What is meant by joins?

1043

Explain the difference between sql and oracle?

1059

What is the oracle implicit cursor?

1035