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

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

Question Posted / nanne

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

Explain an extent?

1048

How to see free space of each tablespace?

967

Why do you create or replace procedures rather that drop and recreate.

946

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2246

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2574

What is object data modeling?

904

Can multiple columns be used in group by in oracle?

926

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

1979

Describe the types of sub query?

938

What is meant by joins?

1013

What are the differences between char and varchar2 in oracle?

1072

Point out the difference between user tables and data dictionary?

930

Can group functions be mixed with non-group selection fields?

955

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

901

Is postgres faster than oracle?

969